MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: field equal to OR between 2 fields?
Posted by: Jason McIver
Date: September 12, 2009 11:40PM

Thanks for your feed back, it was very helpful. I also found this useful
http://www.databasejournal.com/features/mysql/article.php/10897_1382791_1/Optimizing-MySQL-Queries-and-Indexes.htm

I think I'll index (start,end) and limit to 10 as I don't need time.

Thanks again!

Jason

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
field equal to OR between 2 fields?
4259
Jason McIver
September 11, 2009 03:48AM
Re: field equal to OR between 2 fields?
5144
Rick James
September 12, 2009 09:03AM
Re: field equal to OR between 2 fields?
2205
Jason McIver
September 12, 2009 11:40PM


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.