Online Documentation for SQL Manager for Oracle

Selecting objects


This step of the wizard allows you to select objects of the specified type for the statistics operation.

 

Note that this step is only available if you have specified the following object types to get statistics for at the previous step:

RadioButton Schema

RadioButton Table

RadioButton Index

 

Advanced Statistics Wizard - Selecting objects

 

If you have specified RadioButton Schema as the object type to get statistics for, you should select schema(s) for the statistics operation.

 

To select a schema, you need to move it from the Available list to the Selected list. Use the Move all to Selected Move to Selected Move to Available Move all to Available buttons or drag-and-drop operations to move the objects from one list to another.

 

If you have specified RadioButton Table as the object type to get statistics for, you should select table(s) for the statistics operation.

 

Schema

Use the drop-down list to select the schema to get tables from.

To select a table, you need to move it from the Available list to the Selected list. Use the Move all to Selected Move to Selected Move to Available Move all to Available buttons or drag-and-drop operations to move the objects from one list to another.

 

If you have specified RadioButton Index as the object type to get statistics for, you should select index(-es) for the statistics operation.

 

Schema

Use the drop-down list to select the schema to get indexes from.

To select an index, you need to move it from the Available list to the Selected list. Use the Move all to Selected Move to Selected Move to Available Move all to Available buttons or drag-and-drop operations to move the objects from one list to another.

 

Click the Next button to proceed to the Specifying additional settings step of the wizard.