MySQL Forums
Forum List  »  Performance

What index to use for "where col is IS NOT NULL" query
Posted by: Pura Vida
Date: October 24, 2013 12:05PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
What index to use for "where col is IS NOT NULL" query
1490
October 24, 2013 12:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.