Re: Need Statspack help

PaulW wrote:

> 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!
> 

FTS are not necessarily bad; one read will be faster than 2 (index+table).

> 

Stored outlines, anyone?

>>
>>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

-- 

Regards,
Frank van Bortel