SQL & PL/SQL

Hi Friends,

I have a simple query like:

SELECT *
 FROM  APPS.RCV_SHIPMENT_HEADERS RSH
WHERE RSH.ASN_TYPE = 'ASN'
    AND RSH.SHIPMENT_NUM IS NOT NULL
    AND RSH.ATTRIBUTE7 IS NULL

As expected, there should be a FULL TABLE SCAN on the table because of "IS NULL" and "IS NOT NULL" conditions and it is true.
The optimizer is going for a FULL TABLE SCAN.

Is there any way to avoid this?

DB Version: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production

Regards,
Sreekanth Munagala.