Skip to Main Content
Forums

SQL & PL/SQL

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!

What index to use for "where col is IS NOT NULL" query

PuraVidaOTNOct 25 2013 — edited Oct 25 2013

If I need a query of the form:

 

select * from INV_TABLE where R_TIMEOUT IS NOT NULL

 

What kind of index do you suggest on the R_TIMEOUT column?

Note that I am only interested in whether it is being null or not.

 

Thanks.
This post has been answered by John Spencer on Oct 25 2013
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 22 2013
Added on Oct 25 2013
#index, #not
5 comments
4,289 views