Re: Tuning queries with "IS NULL" / "IS NOT NULL" conditions
- From: Srinivas Chintamani <srinivas.chintamani@xxxxxxxxx>
- To: Martin Klier <usn@xxxxxxxxx>
- Date: Sat, 30 Jan 2010 20:07:36 -0500
On Sat, Jan 30, 2010 at 10:35 AM, Martin Klier <usn@xxxxxxxxx> 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
Other related posts:
