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:
| Index Name | Indexed Fields | Type |
|---|---|---|
| IX_TABLENAME_DATEADDED | DATEADDED | Clustered |
| PK_TABLENAME | ID | Non-clustered |
| Index Name | Indexed Fields | Type |
| IX_TABLENAME_DATEADDED | DATEADDED | Clustered |
| PK_TABLENAME | ID | 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.