Исходное состояние индексов:
Скрипт создания новых индексов:
USE Tester;
CREATE INDEX Ind_Acc ON dbo.Account (Full_Name); -- NON-CLUSTERED, NON-UNIQUE
CREATE UNIQUE NONCLUSTERED INDEX PK_Account_MyKey ON dbo.Account([Id] ASC)
WITH (PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF,
SORT_IN_TEMPDB = OFF,
IGNORE_DUP_KEY = OFF,
ONLINE = OFF,
FILLFACTOR = 80,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON);
CREATE UNIQUE NONCLUSTERED INDEX Ind_Acc2 ON dbo.Account (Full_Name); -- NON-CLUSTERED, NON-UNIQUE
Созданные индексы:
Скрипт удаления индексов:
DROP INDEX Ind_Acc ON dbo.Account;
DROP INDEX PK_Account_MyKey ON dbo.Account;
DROP INDEX Ind_Acc2 ON dbo.Account;