Topic
  • 1 reply
  • Latest Post - ‏2012-12-19T00:41:06Z by YuanFeng
SystemAdmin
SystemAdmin
1632 Posts

Pinned topic RUNSTATS options in generated scripts

‏2012-12-18T16:17:40Z |
Hi,
Does anybody know what runstats option will be used when DS change plan generate a deployment script? options such as WITH DISTRIBUTION AND SAMPLE DETAILED INDEXES ALL etc..

So far I have not seen it being included in the generated RUNSTATS statements.

What is the default option it will generate and is there a way to change the default option being generated?

Thanks
Updated on 2012-12-19T00:41:06Z at 2012-12-19T00:41:06Z by YuanFeng
  • YuanFeng
    YuanFeng
    81 Posts

    Re: RUNSTATS options in generated scripts

    ‏2012-12-19T00:41:06Z  
    Hi,
    currently we don't use any option in deploy script for runstats,we will think about in futue release, you can go to the runstats TA(select the table,right click you will see the runstats) for complex options