Answer Happy

Which one of the following indexes would you choose to create to improve the runtime of the following SQL query that finds the names of all restaurants which are located in the Inner West neighbourhood? SELECT R.name FROM Restaurants R, Neighbourhoods N WHERE ST_Contains (N.geom, R.location) = True AND N.name = 'Inner West'; O A GIST/R+-tree index on Neighbourhoods.geom O A GIST/R+-tree index on Restaurants.location O A B+-tree index on (Restaurants.name, Neighbourhoods.geom, Restaurants.location) O A bitmap index on Neighbourhoods.name O A B+-tree index on (Neighbourhoods.geom, Restaurants.location)