Page 1 of 1
Question 21 2 pts Which of the following indexes would you choose to create to improve the runtime of the following SQL
Posted: Mon Jun 06, 2022 6:04 pm
by answerhappygod
- Question 21 2 Pts Which Of The Following Indexes Would You Choose To Create To Improve The Runtime Of The Following Sql 1 (56.74 KiB) Viewed 19 times
Question 21 2 pts Which of the following indexes would you choose to create to improve the runtime of the following SQL query that lists all actors of long movies with a rating of 5? You can create more than one index. SELECT A.name M.movie_id) FROM Film Actor A JOIN Movie M ON WHERE M. length > 120 AND M.rating (A.plays_in 5; = A bitmap index on Movie(length) A hash index on Movie(length) A B+-tree index on Movie(length) O A bitmap index on Movie(rating) OA B+-tree index on (FilmActor(name), Film(length, rating)) =