by Neil Boyle – First introduced in SQL Server 7.0, and of course available with SQL Server 2000, Index Intersection gives you new options for creating indexes on tables in order to maximize performance.
To demonstrate how Index Intersection works, I am going to use the "authors"
Read More - Register for Free Membership