Create Index wizard options

Since it takes a while for the wizard to recommend the appropriate indexes, you have two options:

• You can have the wizard calculate the indexes while you wait, or
• You can schedule it to run at a specific time, and then review the recommendations later. Use the Jobs page of the Journal notebook, and click the Job history push button to check the results.

After the wizard recommends the indexes to create and drop and you verify the recommendations, you have three options:

• Save the script.
• Save the script and run it while you wait.
• Save the script and schedule it to run at a later time.

If you choose to run the script, now or later, the indexes will be created in the database shown on the Introduction page of the Index wizard.