Creating SQL Objects › Creating an Index

Creating an Index

Use a CREATE INDEX statement to define a key to CA Datacom/DB and the CA Datacom Datadictionary. When a CREATE INDEX statement successfully executes, a KEY entity-occurrence is defined in CA Datacom Datadictionary in PROD status. The five-character DATACOM name of the key is generated for you by CA Datacom Datadictionary. The key's attributes include MASTER-KEY=N, NATIVE-KEY=N, INCLUDE-NIL-KEY=Y, and UNIQUE=N. For information about specifying an SQL key selection override key in either the correlation name or synonym name, see Overriding SQL Key Selection.

CREATE INDEX causes all plans dependent on the indexed table to be marked invalid. You can run a CA Datacom Datadictionary Relationship Report to find out what plans are dependent on a table. See the CA Datacom Datadictionary Batch Reference Guide for information on running a Relationship Report.

Enter the CREATE INDEX statement in the numbered area of an EDIT Source Member Panel. See How to Submit SQL Statements for the steps to obtain the panel and an explanation of the fields on the panel. See CREATE INDEX for the syntax of the statement.

The SQL statement performs the following:

• Specify the index name.
• Specify the table to which the index belongs.
• Define the columns in the index.