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
2245
October 04, 2005 10:04PM
Re: Help with querying large table.
1442
October 05, 2005 01:04AM
1654
October 05, 2005 06:41AM
1373
October 05, 2005 07:28PM
1439
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.