Hey guys!
Another Performance Tuning tip for you, where I will explain and comment on the difference between Seek Predicate and Predicate, where they may seem like the same thing, but they make a big difference in the performance of your queries.
I believe this article should answer a very common question for those just starting out in the field: Does the order of the columns when creating the index make a difference? After reading the entire article, comment below what your opinion is.. lol
Comentários (0)
Carregando comentários…
Dirceu, creating an artificial search predicate is very useful when we have a WHERE clause full of non sargable predicates. This way it is possible to transform sequential reading (scan) into quick search (seek). In item 4 of the article “Building efficient T-SQL codes: Sargability” there is an example of using this approach to speed up the execution of a query.
Cool, thanks for sharing, José