Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is null stored in index 12c

ivwviAug 29 2016 — edited Aug 30 2016

Hi,

I have read that if a query is just need is null records of a column .

Does creating a simple index on column does any good.

If null columns won't be stored in index then searching is_null records will never use index.

Perhaps creating index with concatenate d with a string will use index.

Any suggestions please

Thanks & Regards,

Ivw

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 27 2016

Added on Aug 29 2016

#general-database-discussions

7 comments

1,097 views