Cloudera Labs
Provide feedback on Cloudera Labs

Slow query on one Secondary Index and fast on other

New Contributor

I have two salted global secondary indexes (A and B) on a table with row key (primary key) as the covered column. For both of them, the read single row latency is fine with less QPS, but as QPS increases from the client side, query on one of the indexes (A) becomes 10x slow, while the other (B) remain unaffected. Also, I have noticed that the transmitted bytes in the hbase region server increase drastically while querying on index A. Can you explain this behaviour?