2012-03-24Searching For Ranges

Inequality operators such as <, > and between can use an index just like the equals operator. Even a LIKE-Filter can, under certain conditions, use an index like a range condition.

But these operators put another restriction on the definition of multi-column indexes. This restriction can even lead to cases where you cannot define a correct column order at all.