USE YourDatabaseName;

GO

ALTER INDEX PK_AccessKeys ON Accesskeys

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_AuthProviders ON AuthProviders

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_Brokers ON Brokers

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_DeviceFolderProperties ON DeviceFolderProperties

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX IDX_DeviceFulls_IsDeleted ON DeviceFulls

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_DeviceFulls ON DeviceFulls

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX IDX_DeviceSlims_ISDeleted ON DeviceSlims

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_DeviceSlims ON DeviceSlims

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_FolderAuthProviders ON FolderAuthProviders

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_FolderNotifications ON FolderNotifications

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_FolderPackages ON FolderPackages

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_FolderProfiles_1 ON FolderProfiles

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_Folders ON Folders

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_FolderVirtualDisks ON FolderVirtualDisks

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_GlobalSettings ON GlobalSettings

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_Licenses ON Licenses

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_LicenseUsage ON LicenseUsage

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_LogNotificationQueueItems ON LogNotificationQueueItems

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX "CI-DT" ON Logs

REBUILD;

GO
...........................................
USE YourDatabaseName;

GO

ALTER INDEX IX_Logs_LogType_DateTime_DeviceId ON Logs

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_Logs ON Logs

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX IDX_LogsAPResult_DevicePk ON LogsAPResult

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_APResult ON LogsAPResult

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX IDX_LogsAudit_LogType ON LogsAudit

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX IDX_LogsAudit_UserId_LogType ON LogsAudit

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_Audit ON LogsAudit

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX IDX_LogsEvent_DevicePk_LogType ON LogsEvent

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX IDX_LogsEvent_LogType ON LogsEvent

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_Event ON LogsEvent

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX IDX_LogsEvent2_DevicePk_LogType ON LogsEvent2

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX IDX_LogsEvent2_LogType ON LogsEvent2

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_Event2 ON LogsEvent2

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX IDX_LogsMonitoring_DevicePk_LogType ON LogsMonitoring

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX IDX_LogsMonitoring_LogType ON LogsMonitoring

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_Monitoring ON LogsMonitoring

REBUILD;

GO.....................................

USE YourDatabaseName;

GO

ALTER INDEX PK_Notifications ON Notifications

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_ObjectACEs ON ObjectACEs

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_ObjectLocks ON ObjectLocks

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_ObjectSecurity ON ObjectSecurity

REBUILD;

GO......................................

USE YourDatabaseName;

GO

ALTER INDEX PK_ProfileRevisions ON ProfileRevisions

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_Profiles ON Profiles

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_Roles ON Roles

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_SoftwarePackages ON SoftwarePackages

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_UserAssignments ON UserAssignments

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_Users ON Users

REBUILD;

GO
...........................................

USE YourDatabaseName;

GO

ALTER INDEX PK_VirtualDisks ON VirtualDisks

REBUILD;

GO
...........................................