Index: CustomerID on Orders

Collapse All Expand All

Index Properties

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

Index Columns

	Name	Sort Direction
	CustomerID	ascending

Index Statistics Structure and Age

Extended Properties

SQL

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

See also

Buildmasters.com.au