Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Construct a query to select the first 200 film titles (in ascending alphabetical order) where the film takes place in a 'Boa. You may
1. Construct a query to select the first 200 film titles (in ascending alphabetical order) where the film takes place in a 'Boa. You may assume that the film location is contained within the film table and attribute, description. Additionally, it is alway at the end of the sentence. For example in the following film description: s after the first occurrence of the word 'in' and finishes "A Epic Drama of a Feminist And a Mad Scientist who must Battle a Teacher in The Canadian Rockies" The location is "The Canadian Rockies". Notes for Question 4.1 Boat' can be any boat, U-Boat, JET Boat etc, as long as the location includes the word 'Boat' You do not need to consider the film description output from the trigger you created for question 2.2 . 2. Create a function-based index called IDX_SEARCH_LOCATION that could potentially increase the speed of the query written in 4.1. Write a SQL statement to create an index that best fits that task and explain your choice. 3. Report the execution time of the query statement you wrote in Task 4.1 before and after creating the index in Task 4.2. Explain any difference. If there is no difference, explain why
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started