Skip to main content

where vs. onQuick Tip!

 

For faster run times, move filters from the where clause into the appropriate inner join. The top example is an optimized version of the bottom code. Let me know if you have any other tips or questions!

 

 

Great tip Andrew! There are a few other tips and tricks on the help page that might come handy: https://help.celonis.cloud/help/pages/viewpage.action?pageId=35553823


Reply