Hi Ian,
take a careful look at fragmentation of their
indexes and possible chained rows in the tables. Probably RATE_SCHEDULE_LINK_PK
is a good start point
Also the cardinality (estimated numbers
of output rows for each step) may confuse you if their statistics is lost or
obsolete for some objects
Regards,
Ed
|
Title: Performance problem .... HELP :-(
- Performance problem .... HELP :-( Biddell, Ian
- Re: Performance problem .... HELP :-( Stephane Faroult
- RE: Performance problem .... HELP :-( Biddell, Ian
- RE: Performance problem .... HELP :-( Mark Leith
- Re: Performance problem .... HELP :-( Edward Shevtsov
- Re: Performance problem .... HELP :-( Mike Killough