Fragmentation Expressions for 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
MATCH
LIKE

If the fragmentation expression uses any of the following operators, fragment elimination does not occur for queries on the table.

!=
IS NULL
IS NOT NULL

For examples of fragmentation expressions that allow fragment elimination, see Effectiveness of Fragment Elimination.