MySQL Forums
Forum List  »  Newbie

Re: problem using index
Posted by: David Fells
Date: April 05, 2005 02:18PM

The optimizer can't use an index when you do a SUBSTRING like that. If you use postcode in that fashion, do you really require the space and 2 characters? It looks like you could juse use the numbers.

Options: ReplyQuote


Subject
Written By
Posted
April 05, 2005 09:59AM
Re: problem using index
April 05, 2005 02:18PM
April 05, 2005 04:22PM


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.