Production Ticket(ST) #11177
Updated by Muhammad Arif 7 months ago
example:
USE [DMS_EcoSystem]
GO
ALTER INDEX [NonClusteredIndex-txn_invoice_history_detail_2] ON [dbo].[txn_invoice_history_detail] REBUILD PARTITION = ALL WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO
USE [DMS_EcoSystem]
GO
ALTER INDEX [NonClusteredIndex-txn_invoice_history_detail_2] ON [dbo].[txn_invoice_history_detail] REBUILD PARTITION = ALL WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO