Re: At Performance Limit for 2 GB RAM?
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.
Subject
Views
Written By
Posted
7859
July 20, 2005 09:42AM
Re: At Performance Limit for 2 GB RAM?
3453
July 20, 2005 05:45PM
3308
July 22, 2005 01:33PM
3215
July 22, 2005 02:06PM
3616
July 22, 2005 02:13PM
2831
July 25, 2005 01:40PM
3034
July 26, 2005 03:47PM
2866
July 26, 2005 06:55PM
2974
July 26, 2005 07:06PM
3019
July 27, 2005 09:46AM
2875
July 30, 2005 11:44AM
3479
August 01, 2005 11:18AM
3430
August 04, 2005 07:17PM
3921
August 08, 2005 09:08AM
2950
August 02, 2005 12:59AM
3212
August 08, 2005 09:26AM
2824
August 09, 2005 07:57AM
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.