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
It's up to the capabilities as to what the source handling should be. What translator are you using?