NULL Values are Never Stored in the Index... So an IS Null will take u to a
FTS :)

Cheers,
Ganesh R


-----Original Message-----
From: Sekaran D
[mailto:oracledba-ezmlmshield-x27420975.[Email address protected]
Sent: 30 June 2004 10:53
To: LazyDBA Discussion
Subject: need help on index creation


Hi,
I have a table like
CREATE TABLE tab1
(
a number,
d date,
c varchar2(1)
);


i create one index like

create index tab1_idx on tab1(d,c);

my select statement is

Select a from tab1
Where d > SYSDATE and c IS NULL;

in this case INDEX is accessed

for this query

Select a from tab1
Where ( (d > SYSDATE and c IS NULL )
OR
(d IS NULL and c IS NULL )
);
FULL TABLE ACCESS is performed. How i have to create index for this?

Any one please help me for this.

Thanks,
Sekaran D.
Disclaimer: 'This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the system
manager. Please note that any views or opinions presented in this email are
solely those of the author and do not necessarily represent those of the
company. Finally, the recipient should check this email and any attachments
for the presence of viruses. The company accepts no liability for any damage
caused by any virus transmitted by this email.'


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


------------------------------------------------------------------------
For more information about Barclays Capital, please
visit our web site at http://www.barcap.com.


Internet communications are not secure and therefore the Barclays
Group does not accept legal responsibility for the contents of this
message. Although the Barclays Group operates anti-virus programmes,
it does not accept responsibility for any damage whatsoever that is
caused by viruses being passed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of the
Barclays Group. Replies to this email may be monitored by the Barclays
Group for operational or business reasons.

------------------------------------------------------------------------


Oracle LazyDBA home page