changing plan after restart [message #65232] |
Wed, 23 June 2004 00:57 |
Kostya
Messages: 4 Registered: March 2002
|
Junior Member |
|
|
I've got a problem with changing execution plan after restarting the server (9.2). After the restart the perfomance of the same select increasing dramatically and the plan is changing. The stat info in system tables not lost. Thanks for help
|
|
|
Re: changing plan after restart [message #65234 is a reply to message #65232] |
Wed, 23 June 2004 17:41 |
IA
Messages: 91 Registered: March 2004
|
Member |
|
|
Hi,
Upon restart, you should let your instance warm up first. Most definitely you will experience a difference in performance due to cache not being fully utilized.
Best to compare performance after warm up first.
IA
|
|
|
Re: changing plan after restart [message #65293 is a reply to message #65232] |
Fri, 23 July 2004 13:06 |
Master P
Messages: 6 Registered: July 2004
|
Junior Member |
|
|
If your plan is totally different full table scans before and index scan after reboot you may be facing the bind variable peeking problem.
By the way plans change all the time when there are new stats available and a statement gets aged out of the shared pool and re parsed on subsequent execution.
|
|
|