Recommendations to keep queries performant?

Wondering what are the recommendations to keeping queries performant, which can also be asked as:

“What kind of query patterns degrade the performance significantly?”

For relational databases there’s plenty of such information, so once a query has bad performance it becomes a matter of searching a bit and trying out a few suggestions on how to improve the performance.

I worry about being completely in the dark about the topic with XTDB.

Hey @Sleepful - as a primarily document-oriented database, use of denormalized documents will always be the fastest way to handle performance requirements. XTDB does implement indexes and query planning, but these aspects are not always trivial to work with (something we hope to improve substantially in future!). If you need help with understanding how to exploit the existing indexes and query engine in the meantime though we are always happy to assist with specific examples / guidance.