force index on text & integer joiin
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.
Subject
Views
Written By
Posted
force index on text & integer joiin
4426
February 12, 2007 11:31AM
2034
February 12, 2007 07:35PM
2190
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.