INDEX - Advanced SQL Engine - Teradata Database

Report the SQL create text or create text and detailed statistics for an index.

This option is not valid for geospatial indexes.

index_name

Name of the named index for which the SQL create text or create text and detailed statistics are to be reported.

This option is not valid for geospatial indexes.

UNIQUE

The index for which the SQL create text or create text and detailed statistics are to be reported is unique.

ALL

The ALL option was used to create the index whose detailed statistics are to be reported.

This option is not valid for geospatial indexes.

(column_name_1)

Names of the index columns for which detailed statistics are to be reported.