AdventureWorks
IX_ProductReview_ProductID_Name Index
Description
Nonclustered index.
Properties
File GroupPRIMARY
Space Used40.00 KB
Fill Factor0
Do not Recompute Statistics
Full Text Key
Clustered Index
Primary Key Index
Unique Index
Pad Index
Columns
 ColumnDescriptionSort Order
 ProductIDProduct identification number. Foreign key to Product.ProductID.Ascending
 ReviewerNameName of the reviewer.Ascending
Index Statistics
Average key length23.50
Density0.00
Rows in the Table4
Rows Sampled4
Distribution Steps3
UpdatedJan 8 2010 8:41AM
See Also

Related Objects

Production.ProductReview Table
Production Schema
AdventureWorks Database

 

 


© 2012 All Rights Reserved.

Send comments on this topic.