We create a rule that will transform OR clauses into IN clauses (when possible).
incorrect results for not in on partition columns
Compilation performance issues for large queries
Investigate optimizing the query compilation of long or-list in where statement
Simplify filter predicates for CBO
Transform flat AND/OR into IN struct clause
Support Struct with different field types in query