3.4.1 Index Name

Mandatory.

Specify the name that is to be assigned to the Index.

...

• Many IT departments adopt a naming standard that requires that index table names contain or relate to the associated physical table name. This is to prevent confusion amongst users when they are accessing the physical or indexes.

• For instance, the physical table (and LANSA table definition) of a customer master table might be named CUSMST. The associated indexes might be called:

  CUSMSTV1	Customers ordered by customer name.
  CUSMSTV2	Customers ordered by postcode.
  CUSMSTV3	Customers ordered by state.