MySQL Forums
Forum List  »  Optimizer & Parser

Re: At Performance Limit for 2 GB RAM?
Posted by: KimSeong Loh
Date: July 20, 2005 05:45PM

Try the following and see if there is any difference.

For table y_statsinfo, what is the order of the primary key
(stn_id, metadata_id) or (metadata_id,stn_id) ?
I hope it is (stn_id, metadata_id).

For table y_metadatatemp, you should index the column (metadata_id)

With the above I would expect the optimizer to read table y_statsinfo first using the primary key to find records with stn_id = 1250 then find the matching row in table y_metadatatemp.

But, not sure if it will be better or not.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: At Performance Limit for 2 GB RAM?
2992
July 20, 2005 05:45PM
3059
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.