Re: Performance issue on table queries on increasing size of unrelated tables

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 26 May 2005 12:13:10 -0700
Message-ID: <1117134790.078884.141120@g44g2000cwa.googlegroups.com>

Yes, if the growing tables are accessed by ineficient SQL then this poorly performing SQL could lead to a decline in the performance of the database as a whole because the poorly performing SQL will be performing large amounts of unnecessary IO, flooding the buffer cache, and filling the temp segments.

First run explain plan on your SQL and make sure it is running efficiently.
Then if it is in fact fine, tune the rest of the SQL Once all the SQL has been tuned you can look to see if the DB needs any tuning

HTH -- Mark D Powell -- Received on Thu May 26 2005 - 14:13:10 CDT