Re: Need Statspack help

From: PaulW <paul_widner_at_hotmail.com>
Date: 29 Oct 2004 14:58:11 -0700
Message-ID: <3fdda837.0410291358.42d00a75@posting.google.com>

Oh yes I've been adding indexes where I see table scans to try and increase performance, I don't view this as "tuning" SQL but the DB as it is a DB object. I so wish I could go re-write and "tune" the SQL statements directly!

Paul

> Just because the queries are generated from a packaged application
> doesn't mean you can't tune the SQL...
>
> There may be some 'missing' indexes on certain tables...
>
> If you really can't improve the SQL then you are most likely going to
> benefit from a CPU upgrade (i.e. faster CPU's or more CPUs)
>
> This is because your CPU time is much higher than your wait times
> combined.
>
> This will of course depend on more detailed anaysis.
>
> Matt
Received on Fri Oct 29 2004 - 16:58:11 CDT