Searching for Ranges


Inequality operators such as <, > and between can use indexes just like the equals operator explained above. Even a LIKE filter can—under certain circumstances—use an index just like range conditions do.

Using these operations limits the choice of the column order in multi-column indexes. This limitation can even rule out all optimal indexing options—there are queries where you simply cannot define a “correct” column order at all.

About the Author

Photo of Markus Winand
Markus Winand tunes developers for high SQL performance. He also published the book SQL Performance Explained and offers in-house training as well as remote coaching at http://winand.at/

?Recent questions at
Ask.Use-The-Index-Luke.com

3
votes
2
answers
348
views

pagination with nulls

19 hours ago Rocky 46
pagination
0
votes
2
answers
55
views
2
votes
1
answer
1.9k
views