Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Freezing database statistics
On 23.10.2006 04:39, dbaplusplus_at_hotmail.com wrote:
> Robert Klemme wrote:
> The two satements are different, so their plans have not changed. It > is possible that plan is not the best because statsitics is different > from reality, but plan itself has not changed.
The two statements are the same the very moment you replace those literals with bind parameters. AFAIK they might even be considered the same without any changes when cursor_sharing is set to 'SIMILAR' or 'FORCE'.
> Stored outlines is a technique to freeze some plans and freezing > statsitics is to freeze all the plans.
Now you answered your own question. Why did you ask in the first place if you do not seem to like non affirmative answers?
Regards
robert Received on Mon Oct 23 2006 - 04:22:49 CDT