Yugabyte query redesign

[LexLuthr]

To alleviate stress from multiple Count() queries, we need to recheck our code base.

1. Benchmark the current times
2. Ask large SPs to benchmark
3. Check if we can get rid if Count queries
4. Create covering indexes for PieceDeal if required (it would double up the space required by the table)

[davidd8]

What is the actual "stress" being caused, too many queries, are the Count() queries taking too long, are the tables not indexed properly?