AdventureWorks
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence Index
Description
Primary key (clustered) constraint
Properties
File GroupPRIMARY
Space Used32.00 KB
Fill Factor0
Do not Recompute Statistics
Full Text Key
Clustered Index
Primary Key Index
Unique Index
Pad Index
Columns
 ColumnDescriptionSort Order
Primary KeyWorkOrderIDPrimary key. Foreign key to WorkOrder.WorkOrderID.Ascending
Primary KeyProductIDPrimary key. Foreign key to Product.ProductID.Ascending
Primary KeyOperationSequencePrimary key. Indicates the manufacturing process sequence.Ascending
Index Statistics
Average key length10.00
Density0.64
Rows in the Table67131
Rows Sampled67131
Distribution Steps78
UpdatedJan 8 2010 8:41AM
See Also

Related Objects

Production.WorkOrderRouting Table
Production Schema
AdventureWorks Database

 

 


© 2012 All Rights Reserved.

Send comments on this topic.