Hi, I have a question regarding Optiq functionality during push down operation.
Let's say I have a query like: select name, age from users where country = "India" I have a filter rule that captures the filter as: (country) = India I push down this filter to my data source, but since I have not implemented filters in my data source I return back all rows to Optiq including country <> India. I find that Optiq takes care of filtering country = India. My question is: Looks like in spite of pushing down a filter, Optiq attempts another round of filtration. Though this is good data quality wise, wont this cause a performance impact as filter is being applied in 2 places (Data source and Optiq)? Is there a way to turn off operation at Optiq layer when the operation has been pushed down. Regards, Abishek
