Replace Not Exist with Left Outer Join and Is Null

From: Amit Saroha <"Amit>
Date: Wed, 26 May 2021 14:29:06 +0000 (UTC)
Message-ID: <258487026.168190.1622039346948_at_mail.yahoo.com>

Hi,
In one of the queries TKProof shows, most time is spent in accessing a table thousands of times inside NOT EXIST condition. I am looking for your inputs if it's a promising idea to replace NOT EXIST with the LEFT OUTER JOIN and IS NULL condition? Any inputs in this regard are appreciated.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 26 2021 - 16:29:06 CEST

This message: [ Message body ]
Next message: Sayan Malakshinov: "Re: Replace Not Exist with Left Outer Join and Is Null"
Previous message: Lok P: "Re: Locking issue"
Next in thread: Sayan Malakshinov: "Re: Replace Not Exist with Left Outer Join and Is Null"
Reply: Sayan Malakshinov: "Re: Replace Not Exist with Left Outer Join and Is Null"
Reply: Jonathan Lewis: "Re: Replace Not Exist with Left Outer Join and Is Null"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message