MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Want ORDER BY to use indexed portion of long text field
Posted by: KimSeong Loh
Date: November 15, 2007 03:51PM

Once you used a function, index becomes unusable, even though the functions are not disrupting the index usage as in LEFT()

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


Subject
Views
Written By
Posted
Want ORDER BY to use indexed portion of long text field
6687
Bob Fitterman
October 13, 2007 07:03AM
Re: Want ORDER BY to use indexed portion of long text field
2891
Chris Schneider
October 24, 2007 03:06PM
Re: Want ORDER BY to use indexed portion of long text field
3051
Bob Fitterman
November 15, 2007 09:20AM
Re: Want ORDER BY to use indexed portion of long text field
2754
KimSeong Loh
November 15, 2007 03:51PM


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.