SQL Server Indexing: How database engine chooses an index for a query?
When it comes to query optimization, all developers know adding an index would make the query faster BUT most of them don't know how SQL Server picks an index for a query?
When you create a composite index (multiple columns) do you know on which conditions that index will be used?
In this video, I've tried to explain the hidden parts of indexing in a database engine.
#sqlserver #indexing #queryoptimization
-----------------------------
LinkedIn Profile:
/ sa-es-ir