Fragmentation expressions for fragment elimination
Some operators in expressions result in automatic fragment elimination.
When the fragmentation strategy is defined with any of
the following operators, fragment elimination can occur for a query
on the table.
IN
=
<
>
<=
>=
AND
OR
NOT
IS NULL (only when not combined with other expressions using AND or OR operators)If the fragmentation expression uses any of the following
operators, fragment elimination does not occur for queries on the
table.
!=
IS NOT NULLFor examples of fragmentation expressions that allow fragment elimination, see Effectiveness of fragment elimination.