(Itzik Ben-Gan) Supporting your query filters with the correct indexes is essential for optimal query performance. When your query filter has a single predicate that’s a search argument (SARG), things are straightforward: You create an index with the filtered column as the key.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help