Join Causing Performance issue, is there a way to write a query using Exists

Question

Team,&nbsp;The With Temp1 is executing in 10 secs and it fetches - 700 records.&nbsp;The FT_BASE table should fetch only the SUBSCRIBER_ID's that are there in Temp1 Table.&nbsp;I have highlighted the statement which is causing the performance, please let me know if there is any alternate way of writing the query in Using 'Exists' OR IN.&nbsp;The Final results should show only 700 Subscriber ID's&nbsp;Thanks!Bindu

fernando eggert · Answer

Bindu, your really need all those joins in the CTE?
You also don't need to use all those columns inside the CTE, you can comment everething different from PRIMARY_SSCR_ID in the CTE.
That TO_CHAR(PRI.SUBSCRIBER_ID) AS PRIMARY_SSCR_ID can also be causing problems to you, why do you need that, if the join is a self join in the end?

Forum Discussion

Join Causing Performance issue, is there a way to write a query using Exists

Share

Resources