Open topic with navigation

Indexes

The Indexes element allows you to define columns to create non-clustered indexes on the table in SQL Server.

The following indexes are automatically created:

Automatically Created Indexes
Index Name Indexed Fields Type
PK_<TABLENAME> ID Non-clustered
IX_<TABLENAME>_DATEADDED DATEADDED Clustered
IX_<TABLENAME>_DATECHANGED DATECHANGED Non-clustered

For a discussion about non-clustered indexes and query performance, see Joe Webb's article at simple-talk: Using Covering Indexes to Improve Query Performance.