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 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
Please upload the att... View full answer
Get step-by-step solutions from verified subject matter experts
