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?
Pinned topic RUNSTATS options in generated scripts
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-12-19T00:41:06Z at 2012-12-19T00:41:06Z by YuanFeng
YuanFeng 2700030G5D81 Posts
Re: RUNSTATS options in generated scripts2012-12-19T00:41:06ZThis is the accepted answer. This is the accepted answer.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