Can you share the output you see from the EXPLAIN? Does it differ
between times it's "fast" and times it's "slow"?
Sharing the table(s) DDL statements would also help, along with the
shape and version of your cluster (e.g. Apache Phoenix 4.14.2 with 8
RegionServers).
Spit-balling ideas:
Hi
We have an issue with our production environment - from time to time we notice
a significant performance degradation for some queries. The strange thing is
that the EXPLAIN operator for these queries takes the same time as queries
execution (5 minutes or more). So, I guess, the issue is