MySQL Forums
Forum List  »  Optimizer & Parser

force index on text & integer joiin
Posted by: Simon Cranmer
Date: February 12, 2007 11:31AM

Yes i know the person who created the table needs shooting but the table is built and fed by a 3rd party product. I need to link several other tables to the varchar field. Anyone know how to get table2 to use the index for the join??

engine = MyISAM
version = 4.1.22

table1 id = INT(11)
table2 mdata= VARCHAR(30)

both tables have indexes on these fields and mdata will only ever contain an integer

TA

Simon.

Options: ReplyQuote


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


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.