How does the database engine decide which index to use for a query?
The query optimizer in the database engine decides which index to use based on several
factors:
The query optimizer in the database engine decides which index to use based on several
factors: