2005/11/25, Jose Dillet <[EMAIL PROTECTED]>: > So, for more than 50 terms if table is accesed by primary key, or for more > than 40 terms if table is accesed by and indexed column, strategy "DIFFERENT > STRATEGIES FOR OR-TERMS" seems to be discarted. So, I'm changing > configuration of jboss to get queries with a limited number of > or terms, but I'd like to know if quantity of or-terms to discard or-terms > strategy is fixed, or is related to some database parameters, or maybe > depends of size of table accesed.
I guess the optimizer looks at statistics and decides that with a certain number of OR terms a full table scan is cheaper than n index lookuops. Just out of curiosity: did you try to change the query to use "in (...)"? What did it look like? Kind regards robert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
