MySQL Forums
Forum List  »  Optimizer & Parser

Re: At Performance Limit for 2 GB RAM?
Posted by: Jay Pipes
Date: July 30, 2005 11:44AM


There's really no need for the metadatatemp join, as far as I can tell. You can reduce the query to:

, COUNT(*) as count
FROM y_statsinfo as stats
WHERE stn_id = 2500
GROUP BY dich_value;

with no effect. For this query, having an index on (stn_id, dich_value) would be beneficial, but only if the number of rows returned by the stn_id = 2500 filter is less than around 35% of the total rows in the table. If not, it would be faster to do a simple table scan. Either case, if you're working with the majority of 20M rows in the index, a sequential scan is about the best you can do...

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster?

Options: ReplyQuote

Written By
Re: At Performance Limit for 2 GB RAM?
July 30, 2005 11:44AM
August 04, 2005 07:17PM

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.