1 Reply Latest reply on Apr 18, 2016 2:28 PM by Steven Hawkins

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

    Anil Nair Newbie

      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