Re: Many request or big request (many OR)?
Posted by:
Rick James
Date: March 08, 2011 01:49AM
Are you checking chp against the empty string 100 times? Let's assume you are checking against 100 different values. Then this is probably than any of your suggestions:
WHERE chp IN ('a', 'bb', 'ccc', ...)
And, yes, it is helpful for chp to be indexed (PRIMARY KEY or other type of INDEX).
Subject
Views
Written By
Posted
3890
March 06, 2011 11:21AM
Re: Many request or big request (many OR)?
1647
March 08, 2011 01:49AM
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.