The Collect Statistics wizard automatically generates the collect statistics SQL which can be previewed using the SQL Preview page.
The options are:
Option | Description |
---|---|
Save SQL | Saves the SQL to the file you select. |
Show In Editor | Displays the SQL in the SQL Editor. The Collect Statistics wizard does not close. |