MySQL Forums
Forum List  »  Newbie

Re: Why Isn't This Index Being Applied?
Posted by: Andrew West
Date: June 08, 2009 02:57PM

Well, I've come to realize most of the problem. The separate portions of the WHERE clause are very large. For example, there are MANY entries such that "IP_BEG <= ?" and MANY entries such that "IP_END >= ?". It is just the union of these two which is tiny. Given this fact, how can the query be improved?

Options: ReplyQuote


Subject
Written By
Posted
Re: Why Isn't This Index Being Applied?
June 08, 2009 02:57PM


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.