Implementing stored outlines from one instance to other
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Implementing stored outlines from one instance to other

  1. #1
    Join Date
    Aug 2002
    Posts
    40

    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

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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

  3. #3
    Join Date
    Jul 2004
    Location
    bangalore
    Posts
    24
    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

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    What if statistics are different on source and target ? You can't acheive the plan stability of source on target.
    Reddy,Sam

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  6. #6
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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
  •  



Click Here to Expand Forum to Full Width