Re: Tuning queries with "IS NULL" / "IS NOT NULL" conditions
Date: Sat, 30 Jan 2010 20:07:36 -0500
On Sat, Jan 30, 2010 at 10:35 AM, Martin Klier <usn_at_usn-it.de> wrote:
> 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.