Clustered Index: | |
Primary Key Index: | |
Unique Index: | |
Ignore Duplicates: | |
Pad Index: | |
Allow Row Locks: | |
Allow Page Locks: | |
Is computed column in index: | |
Located On: | PRIMARY |
Size KB: | 1408 |
Fill Factor: | 0 |
Don't Recompute Statistics: | |
Description: | Nonclustered index. |
Name | Descending | Included | |
EmailAddress |
Updated: | Apr 26 2006 11:49AM |
Average key length: | 59.16122 |
Density: | 1 |
Rows in the table: | 19972 |
Rows sampled for statistics data: | 19972 |
Distribution steps: | 196 |
CREATE INDEX [IX_Contact_EmailAddress] ON [Person].[Contact]([EmailAddress]) ON [PRIMARY]
GO
See Also
List of indexes