Use the Rebuild Multiple Objects window to identify objects that need to be rebuilt, and then set criteria to rebuild them simultaneously.
You can also rebuild one index or table at a time from the Schema Browser, with a simpler interface.
The Rebuild Multiple Objects feature allows you to simultaneously rebuild multiple indexes, tables, or LOB segments.
To rebuild multiple objects
1. Select Database | Optimize | Rebuild Multiple Objects. 2. Select the Indexes, Tables, or LOB Segments tab. 3. Click the arrow beside to load objects.
4. To quickly eliminate objects that do not need to be rebuilt:
a. Select the Thresholds and Performance Options tab, and complete theConsider objects for rebuild only iffields.
b. Select the tab where you the loaded objects.
c. Click the arrow beside and selectDelete rows for items that fail consideration thresholds.
5. To have Toad recommend indexes to rebuild:
a. Select the checkbox beside indexes you want to examine.
b. Select the Thresholds and Performance Options tab and complete theMark indexes for rebuild only iffields.
c. Select the Indexes tab and click .
Tip:You can click to automatically rebuild the recommended indexes, or click to generate a rebuild script for the recommended indexes (the script is copied to the clipboard and you can paste it into the Editor).
6. Complete the other tabs as necessary. Review the following for additional information: Thresholds
and
Performance Options
Use the following option to...
Use 'Online' option
Have Toad rebuild or move the table or index while it is in use.
Storage Clause Adjustments - Extents Tab
Use the following option to...
Change Extent Sizes to the Following
Change the extent sizes, which overrides any options set in the top part of the window.
If you opt to use this feature, make sure you examine the index before you use it. Because the percent used is a factor, this value can only be obtained by examining the indexes. Note that this is not the PCTUSED storage parameter. This refers to the actual percentage of allocated storage space for the index being used. Adjust
Extent Sizes to Minimize # of Extents
Minimize the number of extents. When this option is selected, the new extent size for each index is calculated as follows: working size equals the total size multiplied by the percent used.
This working size is then passed through theMake extent this size orRound All Extent Sizes to the Nearest Power of...algorithm, as selected. The resulting value is the new initial_extent size. It is also the new next_extent size. Pctincrease is set to zero.
Caution:If some indexed tables are used as large temporary tables but are usually empty, Toad may recommend that you rebuild them because they have zero percent used. If you useAdjust Extent Sizesduring the rebuild, Toad would build the index with small extents that may not hold all of your data later. Avoid this by
either using global temporary tables, or do not rebuild indexes with a percent used of zero.
Storage Clause Adjustments - Tablespaces Tab
Select options to move all objects to different tablespaces, or selectively dependent upon their size.
l If you choose to move indexes to a tablespace based upon
the size of the index, and have chosenBy Index Sizeon the Extents tab, size is based on the total size of the index.
l If you choose to move indexes to a tablespace based upon
the size of the index, and you have chosenBy Extent Size on the Extents tab, then the size is based on the INITIAL extent size, as opposed to the NEXT extent size.
Email Notifications
Select whether to send email notifications after completion. The email is sent to the recipients defined on the Email Settings options page.
See "Email Settings" in the online help for more information.
7. Select the checkboxes for objects to rebuild and click to rebuild them immediately or to create a rebuild script (the script is copied to the clipboard and you can paste it into the Editor).
This procedure explains how to rebuild a single index or table, but you can rebuild multiple indexes and tables at the same time.
To rebuild an index or table
1. Click on the Standard toolbar to open the Schema Browser. 2. Right-click the index in the left-hand side and selectRebuild Index. 3. Select parameters as necessary.
Note:The parameters in this window are defined by Oracle. SeeOracle's documentation for more information. You can also find detailed information about parameters in
Knowledge Xpert. Knowledge Xpert is an extensive Oracle technical resource which you can search in the Quick Search bar.
4. To view the ALTER statement, select the SQL tab. 5. ClickExecute.
Use this function to rebuild a table, including dropping and renaming columns. Notes:
l You can simultaneously rebuild multiple tables with the Rebuild Multiple Objects
feature.
To rebuild a table
1. Click on the Standard toolbar to open the Schema Browser. 2. Right-click the table in the left-hand side and selectRebuild Table.
Tip:You can also selectDatabase | Optimize | Rebuild Table. 3. Select settings as necessary on the Options tab.
4. Select parameters as necessary on the Table Storage and Index Options tabs. 5. To drop a column, double-click a column on the Columns tab.
Note:To rename a column, click to select it, wait until after the mouse double-click time, then click it again. Enter the new name for the column.
6. To view the ALTER statement, select the SQL tab. 7. Click .