Simple Count Query takes 30 - 40 seconds

Jon Melo

I'm wondering if anyone has any suggestions on a better way to approach the query described in this Loom.

• Count of records output
• <1M records
• One conditional on an integer field with an index set up on the same field
• On the launch plan

Michael Udinski

Great question @Jon Melo, it could very well be due to the Launch plan but I've passed this along to our team for further investigation. I'll update here once I have more clarity