Index: PK_Contact_ContactID on table Person.Contact
Index: PK_Contact_ContactID on table Person.Contact
| 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: | 1896 |
| Fill Factor: | 0 |
| Don't Recompute Statistics: | |
| Description: | Primary key (clustered) constraint |
| Name | Descending | Included | |
| ContactID |
| Updated: | Apr 26 2006 11:49AM |
| Average key length: | 4 |
| Density: | 1 |
| Rows in the table: | 19972 |
| Rows sampled for statistics data: | 19972 |
| Distribution steps: | 3 |
CREATE UNIQUE CLUSTERED INDEX [PK_Contact_ContactID] ON [Person].[Contact]([ContactID]) ON [PRIMARY]
GO
See Also
List of indexes