MySQL Forums
Forum List  »  Optimizer & Parser

Re: Problem with index and left join
Posted by: Apachez
Date: May 09, 2006 11:48PM

Since you seem locked by that external product perhaps you can still add a second column to the "external product table" ?

If so you could add a char(32) and md5() the url and have a char(32) in your own table for the joins ?

Still a small possibility of collissions but that could perhaps been taken care by the application layer which manually checks that the url is really the url you are expecting ?

Options: ReplyQuote

Written By
Re: Problem with index and left join
May 09, 2006 11:48PM

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.