Chat now with support
Chat with Support

Toad for Oracle 12.12 - Getting Started Guide

Table of Contents Welcome to Toad Toad Resources Required Privileges Create and Manage Database Connections Editor Basics Schema Browser Basics Data Grid Basics Work with Data Work with Database Objects Work with Code
Write Statements and Scripts Work with the Query Builder Execute Statements and Scripts Save Statements (SQL Recall) Work with PL/SQL Objects Debug Analyze Code Optimize SQL
Customize your Toad Environment Use Other Quest Software Products with Toad

Rebuild an Index

This procedure explains how to rebuild a single index.

Note: You can rebuild multiple indexes and tables at the same time. Rebuild Multiple Objects

To rebuild an index

  1. Click image\Toad0015.gif on the Standard toolbar to open the Schema Browser.
  2. Right-click the index in the left-hand side and select Rebuild Index.
  3. Select parameters as necessary.

    Note: The parameters in this window are defined by Oracle. See Oracle'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 Jump search. Jump Search

  4. To view the ALTER statement, select the SQL tab.
  5. Click OK.

 

Rebuild Multiple Objects

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:
    1. Select the Thresholds and Performance Options tab, and complete the Consider objects for rebuild only if fields.
    2. Select the tab where you the loaded objects.
    3. Click the arrow beside and select Delete rows for items that fail consideration thresholds.
  5. To have Toad recommend indexes to rebuild:
    1. Select the checkbox beside indexes you want to examine.
    2. Select the Thresholds and Performance Options tab and complete the Mark indexes for rebuild only if fields.
    3. 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:
    Tab/Option Description
    Thresholds and Performance Options tab 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 the Make extent this size or Round 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 use Adjust Extent Sizes during 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.

    • If you choose to move indexes to a tablespace based upon the size of the index, and have chosen By Index Size on the Extents tab, size is based on the total size of the index.
    • If you choose to move indexes to a tablespace based upon the size of the index, and you have chosen By 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 tab

    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).

 

Work with Code

Toad provides an intuitive and efficient way to write, run, and test your SQL and PL/SQL code. Toad supports efficient code management for a single developer or a whole team of developers.

 

Write Statements and Scripts

Toad provides an intuitive and efficient way to write, run, and test your SQL and PL/SQL code. Toad supports efficient code management for a single developer or a whole team of developers.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating