Comment by ajhool

Thank you for pointing that out, I agree. I'm just looking for peoples' experiences with their applications, which of course all have different workloads.

People did get the spirit of the question and have provided helpful responses, including context about their query structure/complexity.