First you take

your scissors....

NCI_YXZ Non-aligned
X nonclustered
Primary Filegroup Y Z indexes may be
created on a
filegroup instead of

[Link]

[Link]
[Link]
[Link]
a partition scheme.
When these are
[Link] enabled, they
prevent switching!

Table Partitioning can help performance of

very large databases by breaking the data up OrderHistory NCI_DateZY
into easier-to-digest chunks.
Date X Y Z Date Z Y
FG1
Aligned partitioned
Partition FG2
indexes sit on a partition
scheme.

Partition Function Scheme A They will contain the

partitioning key, whether
The algorithm that defines your boundary you specify it or not.
points based on your Partitioning Key FG3
A Partition Scheme

i o ning Key maps filegroups to a

Pa r t i t Partition Function
NCI_DateXY
ea
to mov d
Date X Z allows
yo u
rtition
e
IT C H option OUT of a pa ion.
r t
The partitioning key is one column-- although it
FG4 The SW rtition IN o -only opera
may be a computed column. o le p a t a d at a )
wh s a me ed
requir
table a CH-M lock
Choose a partitioning key you will specify in the
WHERE clause for most (or all!) of your queries to Partition (S
FG5
support partition elimination.
Scheme B
FG6