indexName

An indexName represents an index. To create an index, use the CREATE INDEX statement.

Syntax

[ schemaName . ] SQL92Identifier

You can qualify an index name with a schemaName. If a qualified index name is specified, the schema name cannot begin with SYS.

Example

DROP INDEX APP.ORIGINDEX;
-- OrigIndex is an indexName without a schemaName 
CREATE INDEX ORIGINDEX ON FLIGHTS (ORIG_AIRPORT)