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:
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);