bq. if the where condition refers to an indexed column and a non indexed
column, it should use the index?
This case also we will not use the index because we need to know the values
of non indexed columns first to apply the filter which we need to get from
the data table. So better to include both
Hi Rajeshbabu,
Thanks for the quick answer!
I will keep an eye on that issue. I was expecting this to be working at
least for local indexes.
So, if the where condition refers to an indexed column and a non indexed
column, it should use the index?
I have tried this, and its not working for me.
--
Hi Jacobo,
The local index will be used if you have any where condition on indexed
column otherwise we need to scan index table and data table for each row.
That's the reason why it's not using local indexes.
There is no index merging currently in Phoenix. There is an improvement
task raised for i
