Hi All,
We have noticed an issue with performance of secondary index in Phoenix
4.7. Consider main table ACT with primary key (K1, K2, K3, K4) and Non PK
columns (M1, M2) and secondary index of form -
CREATE INDEX IF NOT EXISTS act_idx ON ACT(K1, K4, K3, K2);
Query in our use case is -
select
fix is included there.
> Thanks,
> James
>
> On Friday, January 22, 2016, Venkat Raman <vra...@gmail.com> wrote:
>
>> Hi All,
>>
>> We are using secondary indexes and see the following issue. Consider main
>> table ACT with primary key (K1, K2, K3) and c
Hi All,
We are using secondary indexes and see the following issue. Consider main
table ACT with primary key (K1, K2, K3) and column M1 and secondary index
of form -
CREATE INDEX IF NOT EXISTS act_idx ON ACT(K1, K3, K2);
Then query of the following form gives incorrect results -
select /*+