Buildmasters Legacy Database Documentation

Index: OrdersOrder_Details on Order Details

CollapseAll image

Collapse image Index Properties

 Name   Value 
 ID  3
 Fill Factor  0
 Size, KB  16
 Unique Index 
 Primary Key Index
 Clustered Index 
 Located On  PRIMARY
 Ignore Duplicates 
 Don't Recompute Statistics 
 Pad Index 

Collapse image Index Columns

  Name Sort Direction
OrderID ascending

Collapse image Index Statistics Structure and Age

 Name   Value 
Updated 08/25/2008
Average key length 8
Density 0.4323953
Rows in the table 2155
Rows sampled for statistics data 2155
Distribution steps 200

Collapse image Extended Properties

No extended properties defined

Collapse image SQL

CREATE INDEX [OrdersOrder_Details]
    ON [dbo].[Order Details] ([OrderID])
    ON [PRIMARY]
GO

Collapse image See also

[Order Details]


Buildmasters.com.au




Buildmasters Legacy Database Documentation