Inequality operators such as
between can use indexes just like
the equals operator explained above.
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.