Simplifying and reducing the cost of an anti-join query
- by Savitha
Hi,
Could you please help me in simplifying and reducing the cost of the below query?
I tried making it a co-related subquery with NOT EXISTS but it didn't give me any output.
Please note that the table in both main and inner query is the same 'table_1".
SELECT *
FROM Table_1 A
WHERE A.Col1 = 'abcd'
AND (A.Col2, A.Col3) NOT IN
…