Query with NULL
From: bob123 <bob123_at_gmail.com>
Date: Tue, 29 Dec 2009 21:19:22 +0100
Message-ID: <4b3a644b$0$14560$426a34cc_at_news.free.fr>
Hi,
Date: Tue, 29 Dec 2009 21:19:22 +0100
Message-ID: <4b3a644b$0$14560$426a34cc_at_news.free.fr>
Hi,
I have a lot of queries like below:
>select * from bxat.no5
>WHERE (no0_session_id = :wp18 OR :wp18 IS NULL)
>AND (tbname = :wp19 OR :wp19 IS NULL)
so an access full on no5
How can I speed up this query ?
Thanks in advance
(Oracle 9.2.0.6)
Received on Tue Dec 29 2009 - 14:19:22 CST