Does the order of criteria the WHERE clause matter?(weblogs.sqlteam.com)
submitted by
kprernn(1445) 4 years, 3 months ago
Does the order of the search criteria make any difference in Microsoft SQL Server's ability to use indexes or resolve a query? In this post, Joe provides a demonstration of how SQL Server can optimize the WHERE clause to its benefit.
|category: Database
|Views: 38
tags:
SqlServer2005 TSQL Database another
Everyones tags:
Your Tags: