-
Implementing stored outlines from one instance to other
Can we implement stored outlines from one instance, capture statistics and implement the same in other instance.if yes -I would appreciate to know the steps.
Thanks
-
1)Make sure you have statistics exported from Source instance to target.
2)Export stored Outlines from source and import it on target.
3)Test your queries to see Plan stability enabled.
Refer following link for further reading.
http://www.cise.ufl.edu/help/databas...ines.htm#25244
Reddy,Sam
-
I don't think we need both exporting statistics and plan stability will do. Either one is enough.
Thanks and Regards,
Satheesh Babu.S
Thanks and Regards,
Satheesh Babu.S
Bangalore
-
What if statistics are different on source and target ? You can't acheive the plan stability of source on target.
Reddy,Sam
-
Originally posted by sreddy
What if statistics are different on source and target ? You can't acheive the plan stability of source on target.
If you have stored outlines then the statistics are irrelevant, isn't it?
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Thanks! You caught me Jmodic,
Sorry! *Mind some where* I was thinking plan stability thru statistics rather stored outlines(from the perspective of other queries optimization from source to target).
Reddy,Sam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|