Index SmartGuide -- Fields and controls

Introduction page
Workload page (Define a new workload)
Workload page (Select a workload)
Limits page
Calculate page
Recommendations page
Drop page
Summary page
Figure pbullet not displayed. Back
Figure pbullet not displayed. Next
Figure pbullet not displayed. Done
Figure pbullet not displayed. Show SQL (on Summary page only)
Figure pbullet not displayed. Cancel



Introduction page

Figure pbullet not displayed. Database

Figure pbullet not displayed. 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)

Figure pbullet not displayed. Workload name
Figure pbullet not displayed. SQL statements in workload
Figure pbullet not displayed. Import
Figure pbullet not displayed. Add
Figure pbullet not displayed. Change
Figure pbullet not displayed. Remove

Figure pbullet not displayed. Workload name

Use this entry field to enter the name of the workload. The name can be from 1 to 128 characters in length.

Figure pbullet not displayed. 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.

Figure pbullet not displayed. 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.

Figure pbullet not displayed. Add

Click this push button to add SQL statements to the current workload. The Add SQL Statement window opens.

Figure pbullet not displayed. Change

Select a SQL statement and click this push button to open the Change SQL Statement window.

Figure pbullet not displayed. Remove

Select a SQL statement and click this push button. The SQL statement will be removed from the workload.



Workload page (Select a workload)

Figure pbullet not displayed. Workload name
Figure pbullet not displayed. SQL statements in workload
Figure pbullet not displayed. Edit workload
Figure pbullet not displayed. Create new workload

Figure pbullet not displayed. Workload name

Use this drop-down box to select an existing workload.

Figure pbullet not displayed. SQL statements in workload

This table shows the current SQL statements in the selected workload.

Figure pbullet not displayed. 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.

Figure pbullet not displayed. 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

Figure pbullet not displayed. For single-partition database environments only. Set maximum logical size of all indexes
Figure pbullet not displayed. For partitioned database environments only. Set maximum logical size of all indexes per partition
Figure pbullet not displayed. Approximate size of current indexes
Figure pbullet not displayed. Advanced

Figure pbullet not displayed. 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.

Figure pbullet not displayed. Approximate size of current indexes

This field displays the approximate size of the current indexes.

Figure pbullet not displayed. 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

Figure pbullet not displayed. When should the calculation start?
Figure pbullet not displayed. Set maximum time to search for optimal indexes

Figure pbullet not displayed. 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.

Figure pbullet not displayed. 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

Figure pbullet not displayed. Recommended indexes
Figure pbullet not displayed. Workload performance
Figure pbullet not displayed. Show workload details

Figure pbullet not displayed. 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.

Figure pbullet not displayed. 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.

Figure pbullet not displayed. 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

Figure pbullet not displayed. Check any indexes you want to drop
Figure pbullet not displayed. Show related
Figure pbullet not displayed. Uncheck all
Figure pbullet not displayed. Check all

Figure pbullet not displayed. 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.

Figure pbullet not displayed. 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.

Figure pbullet not displayed. Uncheck all

Click this push button to clear all the check boxes that had been selected. None of the indexes will be dropped.

Figure pbullet not displayed. 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

Figure pbullet not displayed. Summary
Figure pbullet not displayed. When I click Done
Figure pbullet not displayed. Show SQL

Figure pbullet not displayed. Summary

This scrollable entry field lists all the actions that will be processed when you click Done.

Figure pbullet not displayed. When I click Done

This box lists the options that are available. Select an option and click Done.