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.'

Oracle LazyDBA home page