Search SSWUG.ORG:



DATABASES

Optimization Tips for Multiple Range Predicates, Part 1 This is an off-site link.  Please review our Terms of Service for additional information.


(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 this article..







comments powered by Disqus