Indexes

From RapidSQL
Jump to: navigation, search

Go Up to Supported Objects

Indexes are optional structures associated with tables. You can create indexes specifically to speed SQL statement execution on a table. When properly used, Indexes are the primary means of reducing disk I/O. Indexes are logically and physically independent of the data in the associated table. Unique Indexes guarantee that no two rows of a table have duplicate values in the columns that define the index.

Creating and editing

Note: Creation and editing of objects of this type is not supported against Sybase IQ datasources.

DBMS platform availability and object actions/operations supported

The following table lists object actions available for this object type. For an introduction to object actions and details on usage of specific actions, see Object actions.

DB2 LUW DB2 z/OS MySQL ORCL PSTGRS * SQL SVR SYB ASE SYB IQ SYB IQ

Allocate Extent

Analyze


Deallocate Unused Space

Disable Index

Drop

DBCC

Estimate Size

Extract

Place

Rebuild Index


Rename

Reorganize /Reorg

Report


Shrink

Transfer Ownership

Update Statistics

Missing Indexes

Missing indexes is a feature which helps you to improve the performance of your system. The Missing indexes functionality proposes you to create new indexes for improving the system in case they are needed.

Availability of Missing Indexes for different DBMS:

DBMS-specific information