Page 1 of 1
Question 21 2 pts Which one of the following indexes would you choose to create to improve the runtime of the following
Posted: Mon Jun 06, 2022 6:10 pm
by answerhappygod
- Question 21 2 Pts Which One Of The Following Indexes Would You Choose To Create To Improve The Runtime Of The Following 1 (42.42 KiB) Viewed 16 times
Question 21 2 pts Which one of the following indexes would you choose to create to improve the runtime of the following SQL query that lists the names of all directors whole directed a film in the 1960s? SELECT D.name FROM Directors D, Film F WHERE F.director = D.id AND F.release_year BETWEEN 1960 AND 1969; O A B+-tree index on Film.release_year O A hash index on Film.release_year O A hash index on (Directors.id, Film.release_year, Directors.name) O A B+-tree index on (Directors.name, Film.release_year) O A bitmap index on Film.release_year