Back
Next
Done
Show SQL (on Summary page only)
Cancel
Back
Next
Done
Show SQL (on Summary page only)
Cancel
Introduction page
Database
Database
This read-only field shows the database in which the recommended indexes will be created. To create indexes in a different database, return to the Control Center and select the index folder of the database in which you want indexes created.
Workload page (Define a new workload)
Workload name
SQL statements in workload
Import
Add
Change
Remove
Workload name
Use this entry field to enter the name of the workload. The name can be from 1 to 128 characters in length.
SQL statements in workload
This table shows the current SQL statements in the workload as well as their names and frequency. To add more statements, click the Add or Import push button. To update the information in a statement, highlight the statement and and click Change. To remove a statement, highlight the statement and click Remove.
Import
Click this push button to import one or more SQL statements from various sources to the current workload. The Import SQL Statements window opens.
Add
Click this push button to add SQL statements to the current workload. The Add SQL Statement window opens.
Change
Select a SQL statement and click this push button to open the Change SQL Statement window.
Remove
Select a SQL statement and click this push button. The SQL statement will be removed from the workload.
Workload page (Select a workload)
Workload name
SQL statements in workload
Edit workload
Create new workload
Workload name
Use this drop-down box to select an existing workload.
SQL statements in workload
This table shows the current SQL statements in the selected workload.
Edit workload
Click this push button to edit the current workload by adding, removing or changing SQL statements. The Edit Workload window opens. Press F1 or click the Help push button for instructions on how to use this window.
Create new workload
If you do not want to select any of the existing workloads, click this push button to create a new workload. The Create Workload window opens. Press F1 or click the Help push button for instructions on how to use this window.
Limits page
Set maximum logical size of all indexes
Set maximum logical size of all indexes per
partition
Approximate size of current indexes
Advanced
Set maximum logical size of all indexes
Select this check box to set the maximum logical size of all indexes and enter the maximum number of megabytes in the entry field on the right. (The physical size may be slightly different, depending on the platform and system settings.) If a maximum number is not specified, the Index SmartGuide will use whatever size it needs to accommodate all indexes. The maximum logical size should be equal to or less than the size of the hard-drive that will be used to create the indexes.
Approximate size of current indexes
This field displays the approximate size of the current indexes.
Advanced
Click this push button to alter the parameters that are used by the optimization algorithm. The Advanced Limits window opens. Press F1 or click the Help push button for instructions on how to use this window.
Calculate page
When should the calculation start?
Set maximum time to search for optimal
indexes
When should the calculation start?
Select the Now radio button to have the server start the calculation of recommended indexes as soon as you click Next. The SmartGuide remains open while the indexes are being calculated.
Select the Later radio button to have the server start the calculation at a later, scheduled time. Note that if you click this radio button, this becomes the last step in the SmartGuide. When you click Done, the Schedule window opens. Enter the date and time when you want the indexes to be calculated. A message box appears (with message number DBA1121) informing you of the job number. Note the job number, as it will be used later to retrieve the results.
You can complete the remaining steps (verifying the indexes, giving meaningful names, and selecting the indexes to drop) when you show the results.
Set maximum time to search for optimal indexes
Select this check box, enter the time and select a unit of time from the the drop-down box on the right. If a maximum time is not specified, the Index SmartGuide will use whatever time it needs to search for optimal indexes. The default is 10 minutes. If the specified time is not enough time to allow the SmartGuide to complete its search, it will display the best indexes that it can find in the allotted time.
Recommendations page
Recommended indexes
Workload performance
Show workload details
Recommended indexes
This table lists the indexes that the SmartGuide recommends for the workload, including their name, size in megabytes, whether the index already exists or not, the table name, and the index columns. Use the scroll bar to view all the recommended indexes.
Workload performance
This group box shows the length of time that your workload will run with existing indexes and with all recommended indexes, in timerons.
Show workload details
Click this push button to view the details of each SQL statement. The Workload Details window opens. Press F1 or click the Help push button for instructions on how to use this window.
Drop page
Check any indexes you want to drop
Show related
Uncheck all
Check all
Check any indexes you want to drop
The table on this page lists the indexes that can be dropped. Select the check boxes of the indexes you want to drop.
Show Related
Click this push button to open the Show Related window, which shows the related objects that might be affected by the indexes you have chosen to drop.
Uncheck all
Click this push button to clear all the check boxes that had been selected. None of the indexes will be dropped.
Check all
Click this push button to select all indexes that are shown in the table. All of the indexes will be dropped. The consequences will be that any database activity that needed those indexes will run slower. The advantage will be that the SQL statements in the workload will run faster.
Summary page
Summary
When I click Done
Show SQL
Summary
This scrollable entry field lists all the actions that will be processed when you click Done.
When I click Done
This box lists the options that are available. Select an option and click Done.
