indexName

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

Syntax [ schemaName . ] SQLIdentifier

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)