- Page 11 Which Of The Following Indexes Would You Choose To Create To Improve The Runtime Of The Following Sql Query That 1 (244.51 KiB) Viewed 20 times
Page 11 Which of the following indexes would you choose to create to improve the runtime of the following SQL query that
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Page 11 Which of the following indexes would you choose to create to improve the runtime of the following SQL query that
Page 11 Which of the following indexes would you choose to create to improve the runtime of the following SQL query that lists all actors of good movies about 'Australia'? You can create more than one index. SELECT A.name = M.movie_id ) FROM Film Actor A JOIN Movie M ON (A.plays_in WHERE M.title LIKE 'Australia%' AND M.rating = 3; A hash index on Movie(plays_in) A B+-tree index on (FilmActor(name), Movie(title)) A B+-tree index on Movie(title) A bitmap index on Movie(rating) A hash index on Movie(title)