Re: Tuning queries with "IS NULL" / "IS NOT NULL" conditions
From: Srinivas Chintamani <srinivas.chintamani_at_gmail.com>
Date: Sat, 30 Jan 2010 20:07:36 -0500
Message-ID: <98c5e2a21001301707s59898a17jf2ca8fcd0354aa31_at_mail.gmail.com>
On Sat, Jan 30, 2010 at 10:35 AM, Martin Klier <usn_at_usn-it.de> wrote:
Date: Sat, 30 Jan 2010 20:07:36 -0500
Message-ID: <98c5e2a21001301707s59898a17jf2ca8fcd0354aa31_at_mail.gmail.com>
On Sat, Jan 30, 2010 at 10:35 AM, Martin Klier <usn_at_usn-it.de> wrote:
> Hi,
>
> it's just a general answer.
>
> But to search for NULLs, you can choose an old trick: Create a
> multi-column-index, with the column you are searching with as first
> column in the index. Now the index DOES contain NULLs.
>
> Now thats an interesting idea to try out. And any idea that I
can at-least try definitely helps. Thank you Martin !
> Hope it helps.
>
> --
Regards,
Srinivas Chintamani
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jan 30 2010 - 19:07:36 CST