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