Range expressions in query

The database server can handle one or two column fragment elimination on queries with any combination of five relational operators in the WHERE clause.

Range expressions use the following relational operators: 
<
>
<=
>=
!=
The database server can also eliminate fragments when these range expressions are combined with the following operators: 
AND, OR, NOT
IS NULL, IS NOT NULL
MATCH, LIKE
If the range expression contains MATCH or LIKE, the database server can also eliminate fragments if the string does not begin with a wildcard character. The following examples show query expressions that can take advantage of fragment elimination: 
columna MATCH "ab*"
columna LIKE "ab%" OR columnb LIKE "ab*"