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