Secondary Performance issue with Phoenix 4.7.0-HBase-1.1

[Venkat Raman <vr...@gmail.com>]

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