Implementing stored outlines from one instance to other

[bonny]

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

[sreddy]

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

[shans]

I don't think we need both exporting statistics and plan stability will do. Either one is enough.

Thanks and Regards,
Satheesh Babu.S

[sreddy]

What if statistics are different on source and target ? You can't acheive the plan stability of source on target.

[jmodic]

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?

[sreddy]

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).