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>


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 Received on Tue Dec 29 2009 - 14:19:22 CST

Original text of this message