In this session, we'll look at when SQL Server can use multiple indexes for a single table, why it does so, and how we can write queries to ensure it uses them.
You will learn:
- How SQL Server uses multiple indexes per table?
- When SQL Server uses multiple indexes per table?
- How to use multiple indexes per table in a query.