An OTT company is maintaining a large disk-based relational database of different movies with the following schema:
Movie(ID, CustomerRating)
Genre(ID, Name)
Movie_Genre(MovieID, GenreID)
Consider the following SQL query on the relation database above:
This SQL query can be sped up using which of the following indexing options?
sql
- AB+ tree on all the attributes.
- BHash index on Genre.Name and B+ tree on the remaining attributes.
- CHash index on Movie.CustomerRating and B+ tree on the remaining attributes.
- DHash index on all the attributes.

