Index: AK_Contact_rowguid on table Person.Contact
Index: AK_Contact_rowguid 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: | 472 |
| Fill Factor: | 0 |
| Don't Recompute Statistics: | |
| Description: | Unique nonclustered index. Used to support replication samples. |
| Name | Descending | Included | |
| rowguid |
| Updated: | Apr 26 2006 11:49AM |
| Average key length: | 20 |
| Density: | 1 |
| Rows in the table: | 19972 |
| Rows sampled for statistics data: | 19972 |
| Distribution steps: | 117 |
CREATE UNIQUE INDEX [AK_Contact_rowguid] ON [Person].[Contact]([rowguid]) ON [PRIMARY]
GO
See Also
List of indexes