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.