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 /*+ INDEX(ACT act_idx) */ K1, K2, K3, K4, M1, M2 from ACT where K1 = ? and K3 = ? order by K1 ,K4 ,K3 limit 10; The above query was very fast in Phoenix 4.4 returning in under a second and on similar data set it takes several seconds in Phoenix 4.7. This seems possibly due to PHOENIX-2601 as limit is not being pushed to the inner query. But for the above query, performance suffers where it may be reasonable to push limit to inner query. Please let me know your thoughts. Regards, Venkat
