ÿþ<html> <head> <title>Update-SqlStatistic</title> </head> <body> <h1>Update-SqlStatistic</h1> <div>Updates statistics.</div> <h2> Syntax </h2> <code>Update-SqlStatistic [-statistic] &lt;Statistic&gt; [[-scanType] {Percent | Rows | FullScan | Resample | Default}] [[-sampleValue] &lt;Int32&gt;] [[-recompute]] [&lt;CommonParameters&gt;]</code> <h2> Detailed Description </h2> <div> The Update-SqlStatistic function updates the specified statistic. </div> <h2> Related Commands </h2> <div> * <a href='Update-SqlStatistic.htm'>Update-SqlStatistic</a><br/> </div> <h2> Parameters </h2> <table border='1'> <tr> <th>Name</th> <th>Description</th> <th>Required?</th> <th>Pipeline Input</th> <th>Default Value</th> </tr> <tr valign='top'> <td>statistic&nbsp;</td> <td>&nbsp;</td> <td>true&nbsp;</td> <td>true (ByValue)&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>scanType&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>sampleValue&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>recompute&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> </table> <h2> Input Type </h2> <div>None You can pipe SMO Statistic objects to Update-SqlStatistic</div> <h2> Return Values </h2> <div>None This function does not generate any output.</div> <h2> Examples </h2> <h3> EXAMPLE 1</h3> <pre>Get-SqlDatabase "Z002\sql2k8" "pubs" | Get-SqlTable -name authors | Get-SqlStatistic | Update-SqlStatistic</pre> <div>This command updates the SQL statistics of the authors table</div> </body> </html>