IN expressions are converted to OR expressions in the filter expression tree in Queries

[anilnair]

Hi All,

When I have a query with IN expression teiid is converting this query to use OR expression. So if I were to send queries with in clause(subquery for a table with large data ) I see comparison being done with a OR expression  and hitting performance of the system.

I would like to know if there is any alternative or best approach to using this

Thanks

Anil

[shawkins]

It's up to the capabilities as to what the source handling should be.  What translator are you using?