I am running a query in the sql editor and it says time out. I would like to know which part of the query takes long run to execute?
I tried to use, "EXPLAIN ANALYZE" before the start of my select query but SFMC doesnt allow. Anyone of you know any commands that SFMC can recognize.
I dont want to split the query and rerun.Any help is highly apprecaited!!
Unfortunately, there's no way to know what's happening behind the scenes as the query runs. The only thing you can really do is to simplify and break apart the query until you have steps that are small enough to run. I'll often check the Q&A on stack exchange as well to see which functions are typically more performant, when faced with options in functions, etc. Many of our most complex actions in SFMC with larger quantities of data will be broken out into 3, 4, or more parts, running step by step in Automation Studio. In addition to the things I've already mentioned, Salesforce has a help article that might help you to know where to optimize. Check it out.
-Aaron
