Poor performance for aggregation queries on sample data

[neha]

Hi @Yuan_Hong,

Thanks for reporting this. We have some inefficiencies in the way we handle large table joins - for example, [YSQL] Improve the performance of NestedLoop joins with Index Scans using batched execution · Issue #4903 · yugabyte/yugabyte-db · GitHub

Once the above issue is fixed, you should see the performance improve significantly.