Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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 BortelReceived on Wed Nov 03 2004 - 06:51:49 CST
![]() |
![]() |