Ranzz (5/26/2011)
Below is the script for creating index and how can I change the script to create index onlie?what are benfits and disadvangates of online and offile?
CREATE NONCLUSTERED INDEX [_dta_index_dClientCode_16_437576597__K7_K3_1] ON [dbo].[dClientCode]
(
[ClientGenericId] ASC,
[Code] ASC
)
INCLUDE ( [ClientCodeId]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [Data_Data]
An online index (build) allows access / modification of the data while the index maintenance operations take place. It is (correct me if I'm wrong) an Enterprise feature. To create an online index, set the ONLINE flag to ONLINE = ON.
I cannot think of any disadvantages but the price of the Enterprise edition 😎