Similar to this action if you read the Books Online page describing the UPDATE STATISTICS command, you will see that there are some undocumented options.
UPDATE STATISTICS table | view
[
{
{ index | statistics_name }
| ( { index |statistics_name } [ ,...n ] )
}
]
[ WITH
[
[ FULLSCAN ]
| SAMPLE number { PERCENT | ROWS } ]
| RESAMPLE
| <update_stats_stream_option> [ ,...n ]
]
[ [ , ] [ ALL | COLUMNS | INDEX ]
[ [ , ] NORECOMPUTE ]
] ;
<update_stats_stream_option> ::=
[ STATS_STREAM = stats_stream ]
[ ROWCOUNT = numeric_constant ]
[ PAGECOUNT = numeric contant ]
<update_stats_stream_option>
This syntax is for internal use only and is not supported. Microsoft reserves the right to change this syntax at any time.
Previously when asked more about these options to the SQL Development team in Microsoft the explanation was a good reason why these options are undocumented, which means they are left for testing and debugging only which are frequently used by MS PSS (CSS). As these 2 options are very much prone to alter the metadata in the table or index which is read by the Query Optimizer when processing queries that access the table and/or index in question. Much information on statistics and indexes can be found about Transferring table statistics between the servers blog post, also you should make sure to make use of best execution plans. How you can do it means, by analyzing and looking at the frequently executed queries to make sure that