Re: force index on text & integer joiin
If you do an outer join, yuo can cast the integer to char(30) and it will use the index.
Try this.
EXPLAIN Select * From table1 Left Join table2 On mdata=CAST(id AS CHAR(30))\G
EXPLAIN Select * From table2 Left Join table1 On id=mdata\G
Subject
Views
Written By
Posted
4426
February 12, 2007 11:31AM
Re: force index on text & integer joiin
2033
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.