You name indexes in the CREATE INDEX statement. In CREATE INDEX and other SQL statements, the names you give to indexes can be qualified by authorization identifiers. NOTE In syntax diagrams, the index-name syntax element refers to either the qualified or unqualified form of the name given to the index in the CREATE INDEX statement. index-name = ---+----------------------------+-> <name-of-index> ---> +---> <schema-name> -+--> . -+ +---> <alias> -------+