Equality expressions in query

The database server can handle one or multiple column fragment elimination on queries with a combination of equality operators in the WHERE clause.

Equality expressions use the following equality operators:
=, IN 
The database server can also eliminate fragments when these equality expressions are combined with the following operators:

Copyright© 2018 HCL Technologies Limited