Запоздалое вступление - Типы построения индексов - Часть 2 (секционированные индексы)

  • Article

- ?????????? ???????????????? ??? ?????????? ?????????????????? ????????:

                  ?????? ???????????????? ?????? ? ???????? ?????????????? ?? ?????, ??????? ????? ???? ???????????? ?? ?????????? ???????? ??????? ? ???? ??????. ?????? ?????????????? ?????????????, ??????? ?????? ????? ?????????????? ? ?????????? ????????. ??????? ??? ?????? ??????????????? ??? ?????? ?????????? ???????? ??? ?????????? ??? ??????? ???????? ??? ??????????. ??? ?????? ?????? ??????? ??? ??????? ?????? ?????????? ? ????? ? ??? ?? ???? ??????.

??????????? ???????????????? ???????:

???? ???????????????? ??????? ????? ???????????? ???????? ?? ????? ??????? ??????, ?????? ????? ????? ?????????????? ???????????????? ???????, ? ??? ????? ??????? ?????? ??? ???. ? ????? ?????? ?????? SQL Server ????????????? ????????? ?????? ?? ?????? ?? ?????? ??? ?? ????? ? ??????? ???????????????, ??? ???????????? ??? ???????. ? ?????????? ?????? ?????????????? ? ???????? ????? ?? ???????, ??? ? ???????, ??? ?????? ??? ??????????? ???????????? ???????.

??? ???????????? ? ??????? ???????? ??????? ????????????? ???????????? ??????? ??????????????? ? ??? ?? ??????. ?????? ??????? ??????????????? ??????? ? ??????? ??????? ?? ?????? ??????????? ???????????, ?? ????:

1) ????????? ??????? ??????????????? ?????? ????? ???? ? ??? ?? ??? ??????,

2) ??????? ?????? ?????????? ?????????? ?????????? ?????? ?

3) ??????? ?????? ?????????? ??? ?????? ?????????? ????????? ????????.

???? ?? ??????? ???????????? ?????? ?? ???????????????? ??????? ? ?? ?????????? ??????? ???????????????, ?? ???? ???????????? ?????? ????? ???????????????? ? ??????????? (??. ??????).

?????? :

Create Partition Function pf (int)

as range right for values (NULL, 1, 100)

                 

Create Partition Scheme ps

as Partition pf

TO ([PRIMARY], [FileGroup1], [FileGroup1], [FileGroup1])

                 

Create table t (c1 int, c2 int)

on ps(c1)

                 

Create Index idx_t on t(c1)

????????????? ???????????????? ??????? :

SQL Server ?? ??????????? ?????? ? ????????, ???? ?? ????? ??? ???????? ???? ??????? ?????? ????? ???????????????, ??? ?????? ??? ??????? ? ????????? ???????? ??????.

?? ?????? ?????????? ?????????????????? ??????? ? ???????????????? ???????? ?? ??? ???????????????? ?????????? ?????? – ??? ????? ????? ????????????? ?????????? ??????? (??. ??????).

?????? :

Create Partition Function pf (int)

as range right for values (NULL, 1, 100)

                 

Create Partition Scheme ps

as Partition pf

TO ([PRIMARY], [FileGroup1], [FileGroup1], [FileGroup1])

                 

Create table t (c1 int, c2 int)

                 

Create clustered Index idx_t on t(c1)

on ps(c1)

?????????: ???? ??????? ???????????????? ?????????? ?????? (?????? ????) ? ?? ??? ????????, ?? ??????? ????????? ???????????????? ? ???????????? ? ??? ?? ?????? ???????????????. ?????????? ?????????? ??????, ????? ?? ?????????? ????? MOVE TO ?? ????? ???????? ???????.

?????? :

Drop Index idx_t on t

WITH(MOVE TO new_ps(c1))

 

? ???? ??????? ??????? ??????????? ?? ?????? ????? ???????????????, ?? ???????????? ??????? ?? ??????????? ?????? ? ???. ????? ???????, ???? ???? ???????????? ??????? ???? ?? ????? ????????? ? ?????????? ????????, ??? ????? ?????? ????????? ?????????????? ? ????????.