A composite index is used for a query that uses logical operators in the search condition.

Name: A composite index is used for a query that uses logical operators in the search condition.
Brand: Quizplus
Rating: 5.0 (37 reviews)

Question

Quizplus · Accepted Answer

A composite index can be used for a query that uses logical operators such as AND, OR or NOT in the search condition. This is because the composite index contains multiple columns and can efficiently retrieve the matching rows based on the combination of values in those columns.

A Composite Index Is Used for a Query That Uses