Re: Help with querying large table.
Try to use the full field of 12 chars instead of a prefix of 9 chars. But, I am not sure of the effect if it will be better or not.
KEY `cusip` USING BTREE (`h_cusip`,`h_co_id`)
Try it and see if it is better or not.
And post the explain again, I was expecting it to use both parts of the key `cusip`
Subject
Views
Written By
Posted
1922
October 04, 2005 10:04PM
Re: Help with querying large table.
1322
October 05, 2005 01:04AM
1501
October 05, 2005 06:41AM
1251
October 05, 2005 07:28PM
1283
October 10, 2005 12:07AM
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.