MySQL Forums
Forum List  »  Optimizer & Parser

Re: force index on text & integer joiin
Posted by: Simon Cranmer
Date: February 13, 2007 07:54AM

Thanks that was it. Stumped me at first but then i also spotted that the column was created in the wrong char set so once i added CAST( id AS CHAR CHARACTER SET latin1 ) we saved 1.8 seconds woo hoo!

Cheers

Simon.

Options: ReplyQuote


Subject
Views
Written By
Posted
4429
February 12, 2007 11:31AM
2035
February 12, 2007 07:35PM
Re: force index on text & integer joiin
2191
February 13, 2007 07:54AM


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.