I am running into issues with Query Length varying greatly from sometimes 10 minutes, to other times 7 seconds. Has anyone run into this? I attempted to use with (NOLOCK) in my queries but it seems that's unsupported. TIA for any insight or guidance!

We have very little visibility into what's going on "behind the scenes" so it can be really frustrating. But there are some things you can do... I'd start by looking at things like subqueries, and any joins that you're doing. For subqueries, see if you can avoid them somehow. For the joins, see if you can you get a sense of whether or not they're based on columns that are indexed. You might want to gradually remove things to determine what is causing the query to run slow.

very frustrating. I'll give it a shot and see if reordering joins helps. I do have a few subqueries, would it make sense to break those out into other Calls? Thanks a bunch, again 🙂

Yeah, I think sub queries are almost always performance killers. If you can break them out, it'll probably help.

Will give that a shot