Buildmasters Legacy Database Documentation

Index: ShippedDate on Orders

CollapseAll image

Collapse image Index Properties

 Name   Value 
 ID  7
 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
ShippedDate ascending

Collapse image Index Statistics Structure and Age

 Name   Value 
Updated 08/25/2008
Average key length 11.79759
Density 0.7877551
Rows in the table 830
Rows sampled for statistics data 830
Distribution steps 194

Collapse image Extended Properties

No extended properties defined

Collapse image SQL

CREATE INDEX [ShippedDate]
    ON [dbo].[Orders] ([ShippedDate])
    ON [PRIMARY]
GO

Collapse image See also

Orders


Buildmasters.com.au




Buildmasters Legacy Database Documentation