Re: Help with querying large table.
Thanks, KimSeong, for your reply. Changing the index length doesn't do much:
select_type: SIMPLE
table: holdings
type: ref
possible_keys: cusip
key: cusip
key_len: 12
ref: const
rows: 8180
Extra: Using where; Using temporary; Using filesort
Queries usually take a few minutes, which kind of leaves the client cold!
If you can figure out something, I'd be very appreciative!
Brent
Subject
Views
Written By
Posted
2245
October 04, 2005 10:04PM
1443
October 05, 2005 01:04AM
Re: Help with querying large table.
1654
October 05, 2005 06:41AM
1374
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.