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. |