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