<< Click to Display Table of Contents >>

Indexes and Index Partitions

Top Previous Next

When it opens, the sheet shows basic information related to indexes for the currently selected table, such as:

Index name

Uniqueness

Index type (Normal, Bitmapped)

Status (Is the Index valid?)

Visibility

Tablespace

Storage information ( Partitioned?, Compressed? % Free?)

Timestamp of creation

Timestamp of last DLL change

Timestamp for the last table analyze

Flags

Cache

Statistics

Parallel

Temporary

Domain index

Freelists

Statistics

IOT

Transactions

Extent Size (K)

Number of extents

Index Type

Usage Monitoring

frmTables_Indexes

 

The following context operations are available:

TablesCreateIndex

Create index

 

Shows a modal dialog for creating a new index on the table.

 

Rename

 

Renames the index. KeepTool drops the index and re-creates it with the new name.

07_Drop

Drop

 

Drops an existing index.

05_Properties

Properties/Alter/Rebuild

 

Shows a modal dialog for viewing or changing storage parameters or for rebuilding the index in another tablespace.

 

Show DLL

 

Shows the DDL statements to create the index.

 

Index statistics

Gather Index Statistics

Uses dbms_stats.gather_index_stats to gather index statistics.

 

 

Delete Index Statistics

Uses dbms_stats.delete_index_stats to delete index statistics.

 

 

Validate Structure

Analyzes index and validates structure.

 

 

Analyze (deprecated)

Allows computing, estimating and deleting of table statistics.

 

Logging

 

Allows logging for the index to be turned on or off.

 

Monitoring usage

 

Allows monitoring to be turned on or off.

TablesEstimateSpace

Estimate space

 

Estimates disk space requirement for the index.

 

Copy to clipboard

Index name

Copies the index name to the clipboard

 

 

Where condition

Generates a WHERE col1 = :col1 ... AND coln = :coln condition about all indexed columns and copies it to the Windows clipboard.

 

Grid View

 

For more information, see object window

Indexed Columns

Further information about the columns associated with an index becomes available by clicking on the plus sign to the left of the index name, such as:

Column name

Nullable, i.e. does the column allow NULL values?

Data type of the column.