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

-1
votes
0
answers
1.2k
views

ORACLE 12C Unstructured Data Management (text mining)

Mar 11 at 09:19 Helraezer 0
oracle unstructured 12c data
1
vote
2
answers
5.6k
views

"Order by RAND()" - can use Index?

Feb 23 at 12:06 Markus Winand ♦♦ 936
random index mysql order-by-rand
0
votes
2
answers
1.4k
views

index for better performance for a merge operation

Feb 20 at 11:43 antilet 1
merge index