An OTT company is maintaining a large disk-based relational database of…

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:
SELECT * FROM Movie, Genre, Movie_Genre
WHERE Movie.CustomerRating > 3.4 AND Genre.Name = “Comedy” AND Movie_Genre.MovieID = Movie.ID AND Movie_Genre.GenreID = Genre.ID;

This SQL query can be sped up using which of the following indexing options?

  1. A.

    B+ tree on all the attributes.

  2. B.

    Hash index on Genre.Name and B+ tree on the remaining attributes.

  3. C.

    Hash index on Movie.CustomerRating and B+ tree on the remaining attributes.

  4. D.

    Hash index on all the attributes

Attempted by 176 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…