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
1920
October 04, 2005 10:04PM
1322
October 05, 2005 01:04AM
Re: Help with querying large table.
1499
October 05, 2005 06:41AM
1251
October 05, 2005 07:28PM
1282
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.