Toad for SQL Server 7.4 - Installation Guide

Defragment Indexes

To defragment an index

1. Select Tools | Administer | Index Fragmentation.

   Note: You can also right-click an index from the Indexes node and select Defragment Index.

2. Select a database.

   Tip: To narrow the search results enter a table or view name.

3. Click Search.

   Note: You can set the scanning mode:

   • Limited—Provides fastest performance, only the parent-level pages are scanned. Fragmentation percent and Page Space Used percent can display as null.
   • Sampled—Provides estimated index statistics, based on 1% sample of all pages. This mode does not show heap indexes fragmentation percent.
   • Detailed—Provides actual index statistics, all pages are scanned.

4. Select one or more indexes.

   Notes:

   • To select indexes with Critical and Warning or Critical Only fragmentation use buttons in the lower part of the pane.
   • You can set fragmentation thresholds for issuing warning and critical statuses in Options.
   • Columnstore indexes cannot be defragmented. Right-click a columnstore index and select Tasks | Rebuild Index instead.

5. Click .

6. Complete the fields as necessary. Review the following for additional information:

   Fill factor setting

   Select one of the following options: OLTP—Select when working with intensively changing data. The fill factor value is automatically set to 85. Data warehouse—Select when working with rarely changing and especially with stored data. The fill factor value is automatically set to 100. Custom—Select to manually enter the fill factor value.

Related

About Tables 

Create and Alter Indexes

Programmability

Stored Procedures

About Stored Procedures

A stored procedure is reusable code that is stored on the database server and can be invoked by other applications. Currently, Toad supports T-SQL stored procedures.

Tip: You can change how objects display in the Object Explorer. For example, you can create custom categories or move objects out of existing categories (such as Programmability and Security) in Tools | Options | Explorer | Objects. See Object Options for more information.

Stored Procedure Details

You can display details about a procedure by selecting it in the Object Explorer. The following table describes the details associated with each stored procedure: