Question: film_category film_id film film_id category_id title category category id name description release_year language_id original_language_id rental_duration film_actor actor_id film_id language language id name rental_rate length

film_category film_id film film_id category_id title category category id name description release_year


language_id original_language_id rental_duration film_actor actor_id film_id language language id name rental_rate length 

 

film_category film_id film film_id category_id title category category id name description release_year language_id original_language_id rental_duration film_actor actor_id film_id language language id name rental_rate length actor replacement cost actor id rating first_name special_features Figure 1 Database schema last_name Task 4 - Indexes 1. Write a SQL statement to find the first 100 films (in ascending alphabetical order of the film titles) that take place in a 'Boat', i.e., the word 'Boat' appears in the film description. (Note: You should avoid using LIKE in the SQL statement and instead use string manipulation functions) 2. In order to potentially speed up the query in Task 4.1, a function-based index could be created on the film table. Write a SQL statement to create an index IDX_BOAT that best fits the task and justify your choice.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Please upload the att... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!