Re: Slow query on very large table
Thank you, thank you for doing SHOW CREATE TABLE.
To fix that _one_ query,
ALTER TABLE ADD INDEX (chrom, Affy_ID);
Then it can be done "using index".
Suggest investigate creating and maintaining summary tables. One should try to avoid accessing summary info from tables this big. Also, maintaining indexes (eg, on INSERT/UPDATE) on this table may lead to disk thrashing.
Subject
Views
Written By
Posted
5327
April 16, 2008 08:54AM
Re: Slow query on very large table
2033
May 28, 2008 09:34AM
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.