- Currently, this MSSQL Stored Procedure will rebuild all the indexes of that particular partition of the selected partitioned table whose index fragementation level is above 20%.
- This phenomenon can be modified by changing the alter command in the autogenerating script.
- Also, the fragementation level could be redefined as required.
- Besides, it only requires a nvarchar data type of parameter. That will contain comma separated names of the partitioned tables.
-
Notifications
You must be signed in to change notification settings - Fork 0
Rebuild fragmented indexes for selected partitioned tables.
License
AasishKumarSharma/AutoIndexingForPartitionTables
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
About
Rebuild fragmented indexes for selected partitioned tables.
Resources
License
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published