check for null value in sql query

I have query like this...

select *
from custTab
where custStatus is null or custStatus > sysdate

I store date in custStatus column.

The above query causes a full table
scan in oracle... because I use "is null" and also "or"...is there an alternative way to do this...

any suggestions/comments...
thanks.. Received on Sat Aug 19 2000 - 23:49:40 CDT