SECONDARY_INDEX

Target database: Azure SQL Database, Azure Synapse SQL

Defining a SECONDARY_INDEX for an entity creates a non-clustered index in the listed target database management systems.

See also:

• SORT_KEY

• PRIMARY_KEY

Usage

Pick one or several attributes and their sorting directions to form the index, and give a name to the index. Add index options if needed.

Notes

Check Export SQL/Entity SQL after defining a SECONDARY_INDEX to see generated DDL.

Examples

Defining a secondary index in Azure SQL Database

Key definition:

KEY NAME: IDX_F_TRIP_PICKUP_DT
KEY TYPE: SECONDARY_INDEX
ATTRIBUTE 1: lpep_pickup_datetime
SORT DIRECTION 1: ASC

DDL generated by Agile Data Engine:

CREATE TABLE [pub].[F_TRIP] (
  ...
);
CREATE INDEX [IDX_F_TRIP_PICKUP_DT] ON [pub].[F_TRIP] ([lpep_pickup_datetime] ASC);