Skip to main content
Question

SQL Search in Functional Objects - Low performance


Forum|alt.badge.img+1

Hi everyone,
I have to develop some SQL Queries, which will be saved as Saved Search within the Functional Objects search window. I noticed that we can’t use the “join” to optimize the execution of the query (Maybe a wrong assumption..).
So, the second option was to used the in/not in or exists/not exists but performance are crap….

See an example below:

 

 

For instance, on the above queries, I stop the execution after 10 minutes……

 

I tried to find another way via the API but nothing seems matching my requirement….

 

Thanks in advance for your suggestion/recommendation

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings