Automating Azure SQL DB index and statistics maintenance using Azure Automation

Yochanan_Rachamim  this is error code in the log table   FAILED : 574RESUMABLE INDEX statement cannot be used inside a user transaction.

got error  when running as  exec dbo.AzureSQLMaintenance 'all', @LogToTable=0, @ResumableIndexRebuild=1

this is error when used with @ResumableIndexRebuild=1

Msg 50000, Level 16, State 1, Procedure dbo.AzureSQLMaintenance, Line 527 [Batch Start Line 572]
Script has errors - please review the log. 

Hi sreedxc - I was trying to run it just now and no error shown, can you please be more specific about the error itself and where it pops up. I will be happy to help

getting error on line 529 

Hi sreedxc - Yes, the latest is always recommended as it includes fixes and improvements.

VKretzer - for multiple database maintenance I would recommend using Elastic Jobs as it makes the maintenance much easier and reliable. 

a common pitfall with automation is the FairShare limit that might just cut the maintenance in the middle of processing. 

Hello Yochanan_Rachamim ; thanks for the great scripts and tutorials!

I'd like to ask a few quick questions:

We have 14 databases on our Azure SQL server. Is it advisable to make separate runbooks/schedules for each or to modify the powershell script to have access to multiple databases (like an array of DB names that gets iterated through).

If the latter, are there any pitfalls I should be aware of (max overall connection time, queues, etc)?

Thanks again!

Hi Yochanan_Rachamim  , i was using earlier version of your code. Should i update the proc?

nreddipalle - Thank you for reporting back. 

I fixed the wrong condition in the procedure. 

you may download the current version and replace it in your environment. 

Again - Thank you for your feedback this is very valuable for me to improve this maintenance script. 

Yochanan.

Hello  , I am running this script successfully via automation account for the past 18 months. As I noticed recently that the script is being updated, I planned to use the updated script and seeing my automation account job getting timed out.. The old script completes the statistics update in approximately around 1 hour (if you notice completed status) but the new script keeps timing out after three hours.

I modified the query to run only for one database and can notice the difference in timings (old script completed in 1 min, compared to 5 min with new script)

Logs with old script:

Starting SQL Server Statistics & Index Maintenance
Running Maintenance on Azure SQL Server: shared-us-east2 for DB: adventintl
-----------------------
set operation = statistics
set mode = smart
set LogToTable = 0
-----------------------
Get statistics information...
---------------------------------------
Statistics Information:
---------------------------------------
Total Modifications: 1176
Modified Statistics: 9
---------------------------------------
Start executing commands...
UPDATE STATISTICS [dbo].[NotificationType] ([_WA_Sys_0000000E_015422C3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Session] ([PK_Session_1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Session] ([IX_Session_Modified_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Session] ([_WA_Sys_00000003_27CED166]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WebserviceRequest] ([PK__Webservi__2AB4D6CFF4EFF75C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WebserviceRequest] ([IX_WebserviceRequest_UserIDDate_include]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WebserviceRequest] ([_WA_Sys_00000004_3C2ACFCE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WebserviceRequest] ([_WA_Sys_00000003_3C2ACFCE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WebserviceRequest] ([_WA_Sys_00000006_3C2ACFCE]) WITH FULLSCAN;
Done

Logs with new script:

Starting SQL Server Statistics & Index Maintenance
Running Maintenance on Azure SQL Server: shared-us-east2 for DB: adventintl
-----------------------
set operation = statistics
set mode = smart
set ResumableIndexRebuild = 0
set RebuildHeaps = 0
set LogToTable = 0
-----------------------
Get statistics information...
---------------------------------------
Statistics Information:
---------------------------------------
Total Modifications: 135703
Modified Statistics: 35
---------------------------------------
Start executing commands...
UPDATE STATISTICS [dbo].[CrmProspectStage] ([PK_CrmProspectStage]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetDay] ([PK__TimeShee__E38EC3F563EA5649]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetDay] ([IX_TimeSheetDay_UserID_Date]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectHistory] ([_WA_Sys_00000012_006D4D87]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectHistory] ([_WA_Sys_00000005_006D4D87]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CreditNoteHistory] ([PK_CreditNoteHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChangeFieldNew] ([PK_TicketChangeFieldNew]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChangeFieldNew] ([IX_TicketChangeFieldNew_FieldName_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChangeFieldNew] 
([IX_TicketChangeFieldNew_TicketChangeID_FieldName_ValueBeforeID_ValueAfterID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitHierarchyType] ([PK_BusinessUnitHierarchyType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ErrorMessageTicket] ([PK_ErrorMessageTicket]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserPMMAAttendance] ([PK_UserPMMAAttendance]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Practice] ([PK_Practice]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserRekognition] ([PK__UserReko__0611769D492CF99C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationType] ([PK_NotificationType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationType] ([_WA_Sys_00000002_015422C3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationType] ([_WA_Sys_00000006_015422C3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationType] ([_WA_Sys_00000003_015422C3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationType] ([_WA_Sys_00000011_015422C3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationType] ([_WA_Sys_00000007_015422C3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationType] ([_WA_Sys_0000000D_015422C3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationType] ([_WA_Sys_0000000E_015422C3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TagGroup] ([PK_TagGroup]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TagGroup] ([UQ_TagGroup]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LegalHold] ([PK_LegalHold]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RptColumnConfig] ([PK_RptColumnConfig]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GivingOrderItem] ([PK_GivingOrderItem]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssessmentGrader] ([PK__Assessme__1E658AF01589B602]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[APMetricType] ([PK_APMetricType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PurchaseOrderForecastMonth] ([PK_PurchaseOrderForecastMonth]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmProspectType] ([PK_CrmProspectType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimesheetOversightType] ([PK_TimesheetOversightType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CreditNoteNextStatus] ([PK_CreditNoteNextStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CreditNoteNextStatus] ([_WA_Sys_00000002_025D5595]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitManagerHistory] ([PK_BusinessUnitManagerHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Event] ([PK_Event]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Event] ([ix_date]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Event] ([ix_parenteventid]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserRememberMe] ([PK_UserRememberMe]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PrintRequest] ([PK_PrintRequest]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeLog] ([PK_NotificationTypeLog]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LikeComment] ([PK_LikeComment]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LikeComment] ([IX_LikeComment_EntityType_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LikeComment] ([IX_LikeComment_Created]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LikeComment] ([IX_LikeComment_EntityGUID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LikeComment] ([IX_LikeComment_EntityID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LikeComment] ([IX_LikeComment_EntityType_CreatedBy_Deleted]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LikeComment] ([IX_LikeComment_IsLike_Deleted_CreatedBy_INC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LikeComment] ([_WA_Sys_0000000C_0371755F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LikeComment] ([_WA_Sys_00000007_0371755F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LikeComment] ([_WA_Sys_00000009_0371755F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LikeComment] ([IX_LikeComment_IsLike_EntityGUID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LikeComment] ([IX_EntityID_EntityType_IsLike_NotDeleted_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RptDimension] ([PK_RptDimension]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RptDimension] ([UQ_RptDimension_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GivingTransaction] ([PK_GivingTransaction]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssessmentQuestion] ([PK_AssessmentQuestion]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssessmentQuestion] ([_WA_Sys_00000009_03B16C81]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[App] ([PK_App]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[App] ([UQ_App_Bundle]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PurchaseOrderHistory] ([PK_PurchaseOrderHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmProvince] ([PK_CrmProvince]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetType] ([PK_TimeSheetType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CreditNoteRevenueInvoice] ([PK_CreditNoteRevenueInvoice]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TAndM] ([PK_TAndM]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TAndM] ([IX_TAndM_CompanyID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TAndM] ([IX_TAndM_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TAndM] ([IX_TAndM_Start]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TAndM] ([UQ_TAndM_CompanyIDName]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CacheNotification] ([PK_CacheNotification]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CacheNotification] ([_WA_Sys_00000003_047AA831]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EventPhoto] ([PK_EventPhoto]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EventPhoto] ([IX_eventPhoto_Date]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EventPhoto] ([UQ_EventPhoto_ReferenceID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserReviewCompleted] ([PK__UserRevi__F787F471A6137A85]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProductionReview] ([PK_ProductionReview]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProductionReview] ([IX_LaborRoleID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProductionReview] ([IX_ProductionReview_ProjectID_RevieweeUserID_ReviewDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProductionReview] ([IX_ProductionReview_ReviewDate_ReviewUserID_inc]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProductionReview] ([IX_ProductionReview_StatusReviewDate_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProductionReview] ([_WA_Sys_00000017_04EFA97D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProductionReview] ([IX_RevieweeUserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProductionReview] ([IX_ReviewerUserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AlbumItemRekognition] ([PK__AlbumIte__26AFA6187FD9718D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeQuery] ([PK_NotificationTypeQuery]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeQuery] ([Unique_NameNotificationTypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeQuery] ([_WA_Sys_00000004_0524B3A7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeQuery] ([_WA_Sys_00000003_0524B3A7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeQuery] ([_WA_Sys_00000005_0524B3A7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Map] ([PK_Map]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RptDimensionSelectType] ([PK_RptDimensionSelectType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GivingTransactionType] ([PK_GivingTransactionType]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssessmentQuestionAnswer] ([PK_AssessmentQuestionAnswer]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PurchaseOrderNextStatus] ([PK_PurchaseOrderNextStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PurchaseOrderNextStatus] ([_WA_Sys_00000002_05AEC38C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmQuestion] ([PK_CrmQuestion]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmQuestion] ([_WA_Sys_00000005_05F8DC4F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmQuestion] ([_WA_Sys_00000004_05F8DC4F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmQuestion] ([_WA_Sys_00000003_05F8DC4F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSlot] ([PK_TimeSlot]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CreditNoteStatus] ([PK_CreditNoteStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TAndMLaborRoleRate] ([PK_TAndMLaborRoleRate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Candidate] ([PK__Candidat__DF539BFC9EC35F03]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Applicant] ([PK__Applican__39AE91486392B4F7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Applicant] ([IX_Applicant_CreatedBy]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Applicant] ([IX_Applicant_Email]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Applicant] ([IX_Applicant_LinkedInID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Applicant] ([IX_Applicant_Modified]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Applicant] ([IX_Applicant_ModifiedBy]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Applicant] ([IX_Applicant_MostRecentStatusID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Applicant] ([IX_Applicant_TargetBusinessUnitID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Applicant] ([IX_Applicant_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Applicant] ([IX_Applicant_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EventSystem] ([PK_EventSystem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EventSystem] ([IX_EventSystem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserSetting] ([IX_UserSetting_UserIDName]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserSetting] ([PK_UserSetting]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserSetting] ([_WA_Sys_00000003_06C2E356]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserSetting] ([_WA_Sys_00000004_06C2E356]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProductionReviewConcern] ([PK_ProductionReviewConcern]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProductionReviewConcern] ([_WA_Sys_00000002_06D7F1EF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MapLocation] ([PK_MapLocation]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RptPivot] ([PK_RptPivot]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GivingVendor] ([PK_GivingVendor]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssessmentQuestionOption] ([PK_AssessmentQuestionOption]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataSource] ([PK__DataSour__28EECD4CC2EE0F10]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PurchaseOrderStatus] ([PK_PurchaseOrderStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmResponseAnswer] ([PK_CrmResponseAnswer]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSlotHistory] ([PK_TimeSlotHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSlotHistory] ([IX_TimeSlotHistory_Action]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSlotHistory] ([IX_TimeSlotHistory_EndTime]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSlotHistory] ([IX_TimeSlotHistory_PriorEndTime]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeQueryLog] ([PK_NotificationTypeQueryLog]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeQueryLog] ([IX_NotificationTypeQueryLog_NotificationTypeQueryID_includes]) 
WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeQueryLog] ([_WA_Sys_00000004_08012052]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmAccount] ([PK_CrmAccount]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TAndMMonth] ([PK_TAndMMonth]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CandidateDimension] ([PK__Candidat__B17A71C8400B0166]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantAttachment] ([PK__Applican__790B5CC547340D02]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserSignificantDate] ([PK__UserSign__29D18156A5089BEA]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProductionReviewGroup] ([PK_ProductionReviewGroup]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityStageGateSet] ([PK_EntityStageGateSet]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityStageGateSet] ([UN_EntityStageGateSet]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityStageGateSet] ([_WA_Sys_0000000A_0917A221]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityStageGateSet] ([_WA_Sys_00000004_0917A221]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityStageGateSet] ([_WA_Sys_00000003_0917A221]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityStageGateSet] ([_WA_Sys_00000002_0917A221]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MapLocationType] ([PK_MapLocationType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RptReport] ([PK_RptReport]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RptReport] ([UQ_RptReport_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GridSetting] ([PK_GridSetting]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssessmentQuestionTemplate] ([PK_Academy_AssessmentQuestionType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EventType] ([PK_EventType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EventType] ([IX_EventType_1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EventType] ([IX_EventType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EventType] ([_WA_Sys_00000005_09946309]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmSalesReview] ([PK_CrmSalesReview]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeZone] ([PM_TimeZone]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeZone] ([_WA_Sys_00000007_09D45A2B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeZone] ([_WA_Sys_00000009_09D45A2B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeZone] ([_WA_Sys_00000003_09D45A2B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeRecipient] ([PK_NotificationTypeRecipient]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeRecipient] ([_WA_Sys_00000003_09E968C4]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeRecipient] ([_WA_Sys_00000004_09E968C4]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeRecipient] ([_WA_Sys_00000002_09E968C4]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeRecipient] ([_WA_Sys_00000005_09E968C4]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmAddress] ([PK_CrmAddress]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TAndMProject] ([PK_TAndMProject]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TAndMProject] ([IX_TAndMProject_ProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TAndMProject] ([IX_TAndMProject_TAndMID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CandidateFunnel] ([PK__CandidateFunnel]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantBusinessRelation] ([PK_ApplicantBusinessRelation]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryEngineBookmark] ([PK_QueryEngineBookmark]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryEngineBookmark] ([IX_QueryEngineBookmark_QueryEngineBookmarkID_Guid]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserSocial] ([PK_UserSocial]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProductionReviewTicket] ([PK_ProductionReviewTicket]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Media] ([PK_MediaID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Media] ([_WA_Sys_00000005_0B129727]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Media] ([_WA_Sys_00000002_0B129727]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Media] ([_WA_Sys_00000003_0B129727]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RptReportDimension] ([PK_RptReportDimension]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Group] ([PK_Group]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Group] ([IX_Group_MetaGroupIDMetaGroupReference]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Group] ([_WA_Sys_0000000C_0B47A151]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Group] ([_WA_Sys_0000000D_0B47A151]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Group] ([_WA_Sys_0000000E_0B47A151]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Group] ([_WA_Sys_00000013_0B47A151]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Group] ([_WA_Sys_0000000B_0B47A151]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Group] ([_WA_Sys_00000006_0B47A151]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Group] ([_WA_Sys_00000008_0B47A151]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Group] ([_WA_Sys_0000000A_0B47A151]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Group] ([_WA_Sys_00000005_0B47A151]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Group] ([_WA_Sys_00000012_0B47A151]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Group] ([_WA_Sys_00000002_0B47A151]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Group] ([_WA_Sys_00000015_0B47A151]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Group] ([_WA_Sys_00000014_0B47A151]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Group] ([UQ_Group_Name]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssessmentResult] ([PK__Assessme__B8018D3479BB1AE6]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssessmentResult] ([IX_AssessmentResult_AssetID_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataSourceColumn] ([PK__DataSour__3D1989BFAF3BF817]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmSalesReviewProspect] ([PK_CrmSalesReviewProspect]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ToolUsage] ([PK_ToolUsage]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeSeverity] ([PK_NotificationTypeSeverity]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeSeverity] ([_WA_Sys_00000002_0BD1B136]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeSeverity] ([_WA_Sys_00000003_0BD1B136]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmAnswerType] ([PK_CrmAnswerType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TaskExtra] ([PK_TaskExtra]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TaskExtra] ([IX_TaskExtra_TicketID_TaskExtraTypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TaskExtra] ([_WA_Sys_00000006_0BF1ACC7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TaskExtra] ([_WA_Sys_00000008_0BF1ACC7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TaskExtra] ([_WA_Sys_00000003_0BF1ACC7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TaskExtra] ([_WA_Sys_00000004_0BF1ACC7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CandidateFunnelKlick] ([PK_CandidateFunnelKlick]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantDaxtraHRXML] ([PK_ApplicantDaxtraHRXML]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantDaxtraHRXML] ([IX_ApplicantDaxtraHRXML_ApplicantID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplate] ([PK_QueryTemplate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplate] ([_WA_Sys_00000007_0C5BC11B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplate] ([_WA_Sys_00000009_0C5BC11B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplate] ([_WA_Sys_0000000A_0C5BC11B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplate] ([_WA_Sys_0000000B_0C5BC11B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplate] ([_WA_Sys_00000002_0C5BC11B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplate] ([_WA_Sys_00000005_0C5BC11B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplate] ([_WA_Sys_0000000E_0C5BC11B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplate] ([_WA_Sys_00000004_0C5BC11B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplate] ([IDX_QueryTemplate_QueryReferenceName]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserSocialType] ([PK_UserSocialType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProductionReviewUserProjectRole] ([PK_ProductionReviewProjectRole]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProductionReviewUserProjectRole] ([_WA_Sys_00000002_0C90CB45]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProductionReviewUserProjectRole] ([_WA_Sys_00000004_0C90CB45]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MediaType] ([PK_MediaType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MediaType] ([UQ_MediaName]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RptReportDimensionValue] ([PK_RptReportDimensionValue]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupEntity] ([PK_GroupEntity]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupEntity] ([UQ_GroupID_EntityType_EntityID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupEntity] ([_WA_Sys_00000007_0D2FE9C3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupEntity] ([_WA_Sys_00000003_0D2FE9C3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupEntity] ([_WA_Sys_00000004_0D2FE9C3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupEntity] ([_WA_Sys_00000005_0D2FE9C3]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([PK__Asset__434923723AD563D6]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([IX_Academy_Asset_IsActive_RemovedDate_Inc]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([IX_academy_asset_IsApproved_RemoveDate]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([IX_academy_Asset_RemovedDate_inc]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([IX_Asset_AssetID_INC]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([IX_Asset_DeletedDate_RemovedDate]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([IX_Asset_GUID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([IX_Asset_ImageAttachmentID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_00000011_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_00000014_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_00000016_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_00000018_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_0000001D_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_00000012_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_00000013_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_00000009_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_0000000B_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_00000002_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_00000005_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_0000000F_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_00000010_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_00000003_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_00000004_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_00000006_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_00000022_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_00000021_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([IX_Asset_ContentAttachmentID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([IX_Asset_PreviewAttachmentID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([IX_Asset_GUID_AssetID_INC]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([IX_Academy_Asset_URLSegment_inc]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([IX_academy.Asset_GUID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Asset] ([_WA_Sys_0000002A_0D3AD6BB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExchangeCalendar] ([PK_ExchangeCalendar]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmSource] ([PK_CrmSource]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tour] ([PK_Tour]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tour] ([IX_Tour_Hidden]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tour] ([_WA_Sys_00000007_0DA4EB0F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tour] ([_WA_Sys_0000000B_0DA4EB0F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tour] ([_WA_Sys_00000009_0DA4EB0F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tour] ([_WA_Sys_0000000A_0DA4EB0F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeSubscription] ([PK_NotificationTypeSubscription]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmCampaign] ([PK_CrmCampaign]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TaskExtraType] ([PK_TaskExtraType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TaskExtraType] ([UQ_TaskExtraType_Type_TicketTemplateTokenID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TaskExtraType] ([IX_TaskExtraType_TicketTemplateID_Name_Type]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TaskExtraType] ([_WA_Sys_00000006_0DD9F539]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TaskExtraType] ([_WA_Sys_00000008_0DD9F539]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TaskExtraType] ([_WA_Sys_00000009_0DD9F539]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TaskExtraType] ([_WA_Sys_00000003_0DD9F539]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CandidateFunnelRaw] ([PK_CandidateFunnelRaw_1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantDimension] ([PK__Applican__45A84782E35850E2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplateCategory] ([PK_QueryTemplateCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplateCategory] ([_WA_Sys_00000002_0E44098D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserSupervisorHistory] ([PK_UserSupervisorHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserSupervisorHistory] ([_WA_Sys_00000002_0E64051E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserSupervisorHistory] ([_WA_Sys_00000003_0E64051E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProfileAnswer] ([PK_ProfileAnswer]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SubsidiaryAutoTransfer] ([PD_SubsidiaryAutoTransfer]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RptReportInstance] ([PK_RptReportInstance]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssetActivity] ([PK__AssetAct__BB1DD4B92CF8935A]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssetActivity] ([UQ_AssetActivity_UserAssetIDCourseID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssetActivity] ([IX_AssetActivity_UserID_INC]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssetActivity] ([_WA_Sys_00000003_0F231F2D]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssetActivity] ([_WA_Sys_00000004_0F231F2D]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssetActivity] ([_WA_Sys_0000000B_0F231F2D]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssetActivity] ([_WA_Sys_00000007_0F231F2D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExchangeCalendarAttendee] ([PK_ExchangeCalendarAttendee]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmWorkType] ([PK_CrmWorkType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourInstance] ([PK_TourInstance]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourInstance] ([IX_TourInstance_TourID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourInstance] ([IX_TourInstance_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourInstance] ([_WA_Sys_00000005_0F8D3381]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeSubscriptionDefault] ([PK_NotificationTypeSubscriptionDefault]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeSubscriptionDefault] ([_WA_Sys_00000002_0FA2421A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeSubscriptionDefault] ([_WA_Sys_00000004_0FA2421A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTypeSubscriptionDefault] ([_WA_Sys_00000003_0FA2421A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmCampaignEnrollmentState] ([PK_CrmCampaignEnrollmentState]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CandidateFunnelRawAttachment] ([PK_CandidateFunnelRawAttachment]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupExtra] ([PK_GroupExtra]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupExtra] ([UN_GroupExtra_GroupID_GroupExtraTypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupExtra] ([_WA_Sys_00000003_100C566E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupExtra] ([_WA_Sys_00000004_100C566E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantDimensionJobType] ([PK_ApplicantDimensionJobType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplatePermission] ([PK_QueryTemplatePermission]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplatePermission] ([_WA_Sys_00000008_102C51FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplatePermission] ([_WA_Sys_00000005_102C51FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplatePermission] ([_WA_Sys_0000000A_102C51FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplatePermission] ([_WA_Sys_00000002_102C51FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplatePermission] ([_WA_Sys_00000006_102C51FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplatePermission] ([_WA_Sys_00000004_102C51FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplatePermission] ([_WA_Sys_0000000B_102C51FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplatePermission] ([_WA_Sys_00000003_102C51FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserSupplier] ([PK_UserSupplier]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserSupplier] ([IX_UserSupplier_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProfileQuestion] ([PK_ProfileQuestion]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tax] ([PK_Tax]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MeetingResource] ([PK_MeetingResource]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleBooking] ([PK__Schedule__DAEE564876C4C2F4]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleBooking] ([IX_ScheduleBooking_ProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleBooking] ([IX_ScheduleBooking_ScheduleBookingRequestID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleBooking] ([IX_ScheduleBooking_StartDate_EndDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleBooking] ([IX_ScheduleBooking_StartDate_EndDate_ProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleBooking] ([IX_ScheduleBooking_StartDate_EndDate_WorkTeamID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleBooking] ([IX_ScheduleBooking_StartDate_Status_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleBooking] ([IX_ScheduleBooking_TargetUserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleBooking] ([IX_ScheduleBooking_TargetUserID_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExternalDataRecord] ([PK__External__59625CF60B40CCDD]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExternalDataRecord] ([UC_ExternalDataRecord_RecordKey]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseApprover] ([PK_ExpenseApprover]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CronInfo] ([PK_CronInfo]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourPlatform] ([PK_TourPlatform]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourPlatform] ([IX_TourPlatform_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmCategory] ([PK_CrmCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CandidateFunnelRawKeyValue] ([PK_CandidateFunnelRaw]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssetAssessmentQuestion] ([PK__AssetAss__85331EF49377D28B]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssetAssessmentQuestion] ([IX_AssetAssessmentQuestion_AssetID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssetAssessmentQuestion] ([IX_AssetAssessmentQuestion_GUID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantDimensionJobTypeInterviewer] ([PK_ApplicantDimensionJobTypeInterviewer]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantDimensionJobTypeInterviewer] ([IX_ApplicantDimensionJobTypeInterviewer]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplateSchedule] ([PK_QueryTemplateSchedule]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplateSchedule] ([UQ_QueryTemplateSchedule_QueryTemplateID_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplateSchedule] ([_WA_Sys_0000000D_12149A71]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplateSchedule] ([_WA_Sys_0000000F_12149A71]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplateSchedule] ([_WA_Sys_00000003_12149A71]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserSystem] ([PK_EmployeeSystem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserSystem] ([_WA_Sys_00000002_12349602]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([PK_Project]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([IX_Project]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([IX_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([IX_Project_1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([IX_Project_AccountManagerUserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([IX_Project_AccountManagerUserID_ProjectID_ProjectStatus2ID_Inc_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([IX_Project_AccountPortfolioID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([IX_Project_CompanyID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([IX_Project_CompanyID_ProjectStatus2ID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([IX_Project_CoreName]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([IX_Project_CreatedDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([IX_Project_Enabled]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([IX_Project_IsOpenAccess_Enabled]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([IX_Project_ProjectID_AccountPortfolioID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([IX_Project_ProjectManagerUserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([IX_Project_ProjectManagerUserID_ProjectID_ProjectStatus2ID_Inc_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([IX_Project_ProjectStatus2ID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([_WA_Sys_0000001A_1249A49B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([_WA_Sys_00000015_1249A49B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([_WA_Sys_00000019_1249A49B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([_WA_Sys_00000006_1249A49B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Project] ([_WA_Sys_0000001C_1249A49B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TaxCompound] ([PK_TaxCompound]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MeetingReview] ([PK_MeetingReview]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleBookingRequest] ([PK__ProjectT__71C01D645A7F0FFA]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleBookingRequest] ([IX_ScheduleBookingRequest_ProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleBookingRequest] ([IX_ScheduleBookingRequest_StartDate_EndDate_ProjectID]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleBookingRequest] ([IX_ScheduleBookingRequest_StartDate_EndDate_WorkTeamID]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleBookingRequest] ([IX_ScheduleBookingRequest_StartDateEndDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupExtraType] ([PK_GroupExtraType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupExtraType] ([_WA_Sys_00000002_12E8C319]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupExtraType] ([_WA_Sys_00000007_12E8C319]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupExtraType] ([_WA_Sys_0000000A_12E8C319]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseCategory] ([PK_ExpenseCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CronSetting] ([PK_CronSetting]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CronSetting] ([_WA_Sys_00000002_1352D76D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourStep] ([PK_TourStep]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourStep] ([IX_TourStep_TourVersionID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmCompany] ([PK_CrmCompany]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmCompany] ([IX_CrmCompany_DefaultAEUserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmCompany] ([IX_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CandidateFunnelStatus] ([PK_CandidateFunnelStatus]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssetExtra] ([PK__AssetExt__F8D69DC6F80DE7DF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantEmailTemplate] ([PK_ApplicantEmailTemplate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserTakeover] ([PK_UserTakeover]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserTakeover] ([UQ_UserTakeover_UserID_TakeoverID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TaxGroup] ([PK_TaxGroup]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MeetingReviewAnswer] ([PK_MeetingReviewAnswer]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleBookingRequestTicket] ([PK__Schedule__6CC8C7698C4C6864]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleBookingRequestTicket] ([IX_ScheduleBookingRequestTicket_ScheduleBookingRequestID]) 
WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupRole] ([PK_GroupRole]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupRole] ([IX_GroupRole_RoleID_GroupID_inc]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupRole] ([_WA_Sys_00000006_14D10B8B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupRole] ([_WA_Sys_00000002_14D10B8B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupRole] ([_WA_Sys_00000008_14D10B8B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupRole] ([_WA_Sys_00000009_14D10B8B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExternalDataValue] ([PK_ExternalDataValue_RecordID_ColumnID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplateToken] ([PK_QueryTemplateToken]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplateToken] ([_WA_Sys_0000000A_14F1071C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplateToken] ([_WA_Sys_0000000C_14F1071C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplateToken] ([_WA_Sys_00000002_14F1071C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplateToken] ([_WA_Sys_00000003_14F1071C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseChargee] ([PK_ExpenseChargee]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseChargee] ([UQ_ExpenseChargee_PartsID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectAdmin] ([PK__ProjectA__8CA1A9598A9216C2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectAdmin] ([IX_ProjectAdmin_ProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectAdmin] ([IX_ProjectAdmin_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectAdmin] ([UQ_ProjectAdmin_ProjectIDUserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CronValidation] ([PK_CronValidation]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourUrlPattern] ([PK_TourUrlPattern]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourUrlPattern] ([IX_TourUrl_TourID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmCompanyContact] ([PK_CrmCompanyContact]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CandidateJobType] ([PK__Candidat__8A250F8058E911E1]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Attempt] ([PK_Attempt]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Attempt] ([IX_Attempt_Session]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantExtra] ([PK_ApplicantExtra]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantExtra] ([UQ_ApplicantExtra]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserTakeoverAnswer] ([PK_UserTakeoverAnswer]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserTakeoverAnswer] ([IX_UserTakeoverAnswer_UserID_TakeoverID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Taxonomy] ([PK_KlickTalkTaxonomy]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Taxonomy] ([IX_Taxonomy_ParentID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Taxonomy] ([_WA_Sys_00000009_166F3B3A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Taxonomy] ([_WA_Sys_0000000A_166F3B3A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MeetingReviewQuestion] ([PK_MeetingReviewQuestion]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MeetingReviewQuestion] ([_WA_Sys_00000006_168449D3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MeetingReviewQuestion] ([_WA_Sys_0000000A_168449D3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MeetingReviewQuestion] ([_WA_Sys_00000008_168449D3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleConfiguration] ([PK__Schedule__F5C4E3003C3FCE6F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleConfiguration] ([IX_ScheduleConfiguration_ProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleConfiguration] ([IX_ScheduleConfiguration_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupType] ([PK__GroupTyp__12195A4D2A519AD8]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupType] ([_WA_Sys_00000007_16B953FD]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupType] ([_WA_Sys_00000009_16B953FD]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupType] ([_WA_Sys_0000000B_16B953FD]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupType] ([_WA_Sys_00000002_16B953FD]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupType] ([_WA_Sys_00000003_16B953FD]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Quiz] ([PK_Quiz]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseChargeeCategory] ([PK_ExpenseChargeeCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectAssignmentHistory] ([PK_ProjectAssignmentHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CurrencyExchangeRate] ([PK_CurrencyExchangeRate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourVersion] ([PK_TourVersion]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourVersion] ([IX_TourVersion_BusinessUnitID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourVersion] ([IX_TourVersion_GroupID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourVersion] ([IX_TourVersion_IsEnabled]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourVersion] ([IX_TourVersion_LaborCategoryID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourVersion] ([IX_TourVersion_TourID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourVersion] ([_WA_Sys_0000000A_172E5549]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourVersion] ([_WA_Sys_0000000E_172E5549]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourVersion] ([_WA_Sys_0000000C_172E5549]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourVersion] ([_WA_Sys_0000000D_172E5549]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContact] ([PK_CrmDepartment]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CandidateSurvey] ([PK__Candidat__2CEB980F8A789E56]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Badge] ([PK__Badge__1918237C98C0DA43]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserTargetHourCountHistory] ([PK_UserTargetHourCountHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Brand] ([PK_Brand]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TaxRateHistory] ([PK_TaxRateHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TaxRateHistory] ([_WA_Sys_00000005_185783AC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MeetingReviewQuestionChoice] ([PK_MeetingReviewQuestionChoice]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MeetingReviewQuestionChoice] ([_WA_Sys_00000007_186C9245]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MeetingReviewQuestionChoice] ([_WA_Sys_0000000B_186C9245]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MeetingReviewQuestionChoice] ([_WA_Sys_00000002_186C9245]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MeetingReviewQuestionChoice] ([_WA_Sys_00000009_186C9245]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleNote] ([PK__Schedule__363FF4C7D7C23F1D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupUser] ([PK_GroupUser]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupUser] ([IX_GroupUser_GroupID_UserID_Deleted]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupUser] ([IX_GroupUser_UserID_Deleted]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupUser] ([_WA_Sys_00000009_18A19C6F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupUser] ([_WA_Sys_00000008_18A19C6F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GroupUser] ([_WA_Sys_00000003_18A19C6F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantExtraType] ([PK_ApplicantExtraType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QuizAnswer] ([PK_QuizAnswer]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseChargeeType] ([PK_ExpenseChargeeType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectBillingType] ([PK_ProjectBillingType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CurrencyType] ([PK_CurrencyType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourVersionInstance] ([PK_TourVersionInstance]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourVersionInstance] ([IX_TourVersionInstance_TourVersionID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourVersionInstance] ([IX_TourVersionInstance_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactAttempt] ([PK_CrmContactAttempt]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CandidateSurveyDimension] ([PK__Candidat__344EE45C3947DF3A]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[BadgeEntity] ([PK__BadgeEnt__77DC4C43DECFE0A0]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserTicketTab] ([PK_UserTicketTab]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Team] ([PK_Team]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MegaMenu] ([PM_MegaMenu]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MegaMenu] ([_WA_Sys_00000004_1A54DAB7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MegaMenu] ([_WA_Sys_00000006_1A54DAB7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MegaMenu] ([_WA_Sys_00000002_1A54DAB7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ScheduleTemplate] ([PK_ScheduleTemplate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GSEMAdGroup] ([PK_GSEMAdGroup]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantJobType] ([PK__Applican__48984E46EA927F2B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantJobType] ([IX_ApplicantJobType_ApplicantID_IsActive_Created]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantJobType] ([IX_ApplicantJobType_ApplicantID_JobTypeID_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantJobType] ([IX_ApplicantJobType_JobTypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantJobType] ([IX_ApplicantJobType_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QuizQuestion] ([PK_QuizQuestion]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClaim] ([PK_ExpenseClaim]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectBooking] ([PK_ProjectBooking]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DailyServiceStore] ([PK_DailyServiceStore]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DailyServiceStore] ([IX_DailyServiceStore_TypeDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourVersionPlatform] ([PK_TourVersionPlatform]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TourVersionPlatform] ([_WA_Sys_00000002_1AFEE62D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactAttemptAttachment] ([PK_CrmContactAttemptAttachment]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CandidateSurveyWatchout] ([PK__Candidat__DD7F6E1F95369CBA]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Bookmark] ([PK__Bookmark__541A3A91E45DA2A9]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Bookmark] ([UC_Bookmark]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Bookmark] ([IX_Bookmark_DeletedDate_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserToken] ([_WA_Sys_00000005_1BBE003C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserToken] ([_WA_Sys_00000001_1BBE003C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TeamMember] ([PK_TeamMember]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TeamMember] ([IX_TeamMember]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MegaMenuRole] ([PK_MegaMenuRole]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MegaMenuRole] ([_WA_Sys_00000002_1C3D2329]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MegaMenuRole] ([_WA_Sys_00000003_1C3D2329]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SchemaMigration] ([PK_SchemaMigration]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SchemaMigration] ([_WA_Sys_00000002_1C5D1EBA]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GSEMAdWord] ([PK_GSEMAdWord]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantLocation] ([PK_ApplicantLocation]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantLocation] ([UN_ApplicantLocation_LocationName]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QuizResult] ([PK_QuizResult]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClaimDecisionNextStatus] ([PK_ExpenseClaimDecisionNextStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClaimDecisionNextStatus] ([_WA_Sys_00000002_1CA7377D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserTracking] ([PK_UserTracking]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserTracking] ([IX_UserTracking_UserID_Created]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectBookingResource] ([PK_ProjectBookingResource]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DailyServiceStoreType] ([PK_DailyServiceStoreType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DailyServiceStoreType] ([IX_DailyServiceStoreType_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DailyServiceStoreType] ([_WA_Sys_00000005_1CDC41A7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DailyServiceStoreType] ([_WA_Sys_00000007_1CDC41A7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Travel] ([PK_Travel]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactAttemptGroupMeeting] ([PK_CrmContactAttemptGroupMeeting]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CandidateTest] ([PK__Candidat__52E576A7E3710717]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateSubscription] ([PK_TicketTemplateSubscription]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateSubscription] ([IX_TicketTemplateSubscription_TicketTemplateID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MemberInvite] ([PK_MemberInvite]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MemberInvite] ([IX_MemberInviteMemberInviteStatusTypeIDExpiredToken_Inc]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MemberInvite] ([IX_MemberInvite_IsLatestRecord_UserID_MemberInviteStatusTypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MemberInvite] ([UQ_MemberInvite_UserIDWhenLatest]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MemberInvite] ([_WA_Sys_00000002_1E256B9B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MemberInvite] ([_WA_Sys_00000005_1E256B9B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SeatingMap] ([PK_SeatingMap]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SeatingMap] ([_WA_Sys_00000004_1E45672C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GSEMUpload] ([PK_GSEMUpload]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Categorization] ([PK__Categori__5F76A20961D80577]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Categorization] ([IX_academyCategorization_CategorizableGUID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Categorization] ([IX_academyCategorization_CategoryID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Categorization] ([_WA_Sys_00000009_1E6562BD]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Categorization] ([_WA_Sys_00000003_1E6562BD]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RecipientEmail] ([PK_RecipientEmail]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RecipientEmail] ([UN_RecipientEmail_Email]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClaimDecisionStatus] ([PK_ExpenseClaimDecisionStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserTreeInclude] ([PK_UserTreeInclude]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserTreeInclude] ([_WA_Sys_00000002_1E9A6CE7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectBudget] ([PK_ProjectBudget_1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Dashboard] ([PK_Dashboard]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelActualBooking] ([PK_TravelActualBooking]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelActualBooking] ([IX_TravelActualBooking_ExpenseItemID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelActualBooking] ([IX_TravelActualBooking_ExpenseRequestID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelActualBooking] ([IX_TravelActualBooking_FromToDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelActualBooking] ([IX_TravelActualBooking_TravelDestinationID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelActualBooking] ([IX_TravelActualBooking_TravelPassID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelActualBooking] ([IX_TravelActualBooking_TraveProviderID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactAttemptGroupMeetingAttachment] ([PK_CrmContactAttemptGroupMeetingAttachment]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[TempSwipeCard] ([PK_dbo.TempSwipeCard]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CandidateTestResult] ([PK__Candidat__971507E02199707C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantOpening] ([PK__Applican__5995F1D4F50DDD25]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MemberInviteStatusType] ([PK_MemberInviteStatusType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SeatingMapLightZone] ([PK_SeatingMapLightZone]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HairlariousContestant] ([PK_HairlariousContestant]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Category] ([PK__Category__19093A2BC0A7AADA]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Category] ([IX_academyCategory_ParentCategoryID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Category] ([_WA_Sys_0000000A_204DAB2F]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Category] ([_WA_Sys_00000004_204DAB2F]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Category] ([_WA_Sys_00000005_204DAB2F]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Category] ([_WA_Sys_00000007_204DAB2F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClaimItem] ([PK_ExpenseClaimItem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClaimItem] ([IX_ExpenseClaimItem_ExpenseItemID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClaimItem] ([IX_ExpenseClaimItem_ProjectExpenseID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserTurnover] ([PK_UserTurnover]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserTurnover] ([_WA_Sys_00000002_2082B559]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserTurnover] ([_WA_Sys_00000004_2082B559]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserTurnover] ([_WA_Sys_00000003_2082B559]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectBudgetTxn] ([PK_ProjectBudgetTxn_1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectBudgetTxn] ([IX_ProjectBudgetTxn_ProjectForecastIDEffective]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DashboardDataHistory] ([IX_DashboardDataHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelActualBookingExpense] ([PK_TravelActualBookingExpense]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelActualBookingExpense] ([IX_TravelActualBookingExpense_TravelActualBookingID]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[BrandIndication] ([PK_BrandIndication]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactCampaign] ([PK_CrmContactCampaign]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TestReport] ([PK_TestReport]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CandidateWatchout] ([PK__Candidat__279062F6ABA8AAC7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantOpeningFulfillment] ([PK__Applican__4FDF42850A969917]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RecipientEmailConsent] ([PK_RecipientEmailConsent]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RecipientEmailConsent] ([UN_RecipientEmailConsent_RecipientEmailID_Entity]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RecipientEmailConsent] ([IX_RecipientEmailConsent]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DashboardPanel] ([PK_DashboardPanel]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DashboardPanel] ([_WA_Sys_00000002_21A0F6C4]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DashboardPanel] ([_WA_Sys_00000003_21A0F6C4]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MetaGroup] ([PK__MetaGrou__B10FF824C108CFC4]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SeatingMapLocation] ([PK_SeatingMapLocation]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SeatingMapLocation] ([IS_SeatingMapLocation_SeatingMapID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SeatingMapLocation] ([IS_SeatingMapLocation_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SeatingMapLocation] ([_WA_Sys_00000005_2215F810]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SeatingMapLocation] ([_WA_Sys_00000006_2215F810]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HairlariousVote] ([PK_HairlariousVote]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Completion] ([PK__Completi__77FA70AFA0468A34]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Completion] ([IX_academyCompletion_GUID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Completion] ([IX_academyCompletion_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Completion] ([IX_Completion_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Completion] ([IX_Academy_Completion_DeletedDate_GUID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Completion] ([_WA_Sys_00000004_2235F3A1]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Completion] ([_WA_Sys_00000008_2235F3A1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClaimNextStatus] ([PK_ExpenseClaimNextStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClaimNextStatus] ([_WA_Sys_00000002_226010D3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[VacationCarryoverRequest] ([PK_VacationCarryoverRequest]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[VacationCarryoverRequest] ([UQ_VacationCarryoverRequest_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectBudgetUserRole] ([PK_BudgetUserRole]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelBookingNote] ([PK_TravelBookingNote_1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactCategory] ([PK_CrmEmployeeCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TestReportAttachment] ([PK_TestReportAttachment]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantScoutTargetEvaluation] ([PK__Applican__F2010ECC3CB6983A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantScoutTargetEvaluation] ([IX_ApplicantScoutTargetEvaluation_ApplicantID]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[DashboardTile] ([PK__Dashboar__DDA83FAD7CF9922E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DashboardTile] ([_WA_Sys_00000002_23893F36]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DashboardTile] ([_WA_Sys_00000003_23893F36]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Metric] ([PK_Metric]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Metric] ([UQ_ShortTitle]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CensorWord] ([PK_CensorWord]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SeatingMapLocationLightZone] 
([UQ_SeatingMapLocationLightZone_SeatingMapLocationID_SeatingMapLightZoneID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HelpContent] ([PK_HelpContent]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HelpContent] ([UQ_HelpContent_TokenTypeBusinessUnitLaborRole]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HelpContent] ([_WA_Sys_00000003_24134F1B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HelpContent] ([_WA_Sys_00000008_24134F1B]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScope] ([PK__ContentS__151C35220B576438]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScope] ([IX_ContentScope_DeletedDate_ContentScopeEntityID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScope] ([_WA_Sys_00000005_241E3C13]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScope] ([_WA_Sys_00000007_241E3C13]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScope] ([_WA_Sys_00000009_241E3C13]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScope] ([_WA_Sys_00000010_241E3C13]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RecipientEmailSentHistory] ([PK_RecipientEmailSentHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RecipientEmailSentHistory] ([IX_RecipientEmailSentHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClaimRole] ([PK_ExpenseClaimRole]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectClientReviewStatus] ([PK_ProjectClientReviewStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelBookingType] ([PK_TravelBookingType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactContactAttemptGroupMeeting] ([PK_CrmContactContactAttemptGroupMeeting]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[TestResult] ([PK_TestResult]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantScreeningTrait] ([PK__Applican__80BB8C1C7633813C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantScreeningTrait] ([IX_ApplicantScreeningTrait_ApplicantID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantScreeningTrait] ([IX_ApplicantScreeningTrait_CreatedBy]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[VacationInfo] ([PK__VacationSettings]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataAggregationType] ([PK_DataAggregationType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataAggregationType] ([UQ_DataAggregationType_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChargeableInternalProject] ([PK_ChargeableInternalProject]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChargeableInternalProject] ([IX_ChargeableInternalProject_ProjectIDEffective]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ServiceTest] ([PK_ServiceTest]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HelpToken] ([PK_HelpToken]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HelpToken] ([IX_HelpToken_ParentID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HelpToken] ([UQ_HelpToken_Token]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScopeBusinessUnit] ([PK__ContentS__F3C139ECE5E20647]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScopeBusinessUnit] ([IX_ContentScopeBusinessUnit_ContentScopeID_inc]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Reminder] ([PK_Reminder]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClaimStatus] ([PK_ExpenseClaimStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectEstimate] ([PK_ProjectEstimate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelCompany] ([PK_TravelCompany]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactEmail] ([PK_CrmContactEmail_1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactEmail] ([IX_CrmContactEmail_Email]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([PK_Ticket]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_TicketGID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_AssignedToUserID_ProjectID_TicketStatusID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_AssignedToUserID_Redacted_ProjectID_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_AssignedToUserID_TicketStatusID_TicketParentID_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_Creted]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_Deadline]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_OwnerUserID_AssignedToUserID_Inc_TicketIDStatusIDTypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_OwnerUserID_Created]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_OwnerUserID_Redacted_ProjectID_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_Project_CompletionDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_ProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_ProjectID_LastUpdated]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_ProjectID_StartDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_ProjectTicketTabID_ProjectID_TicketStatusID_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_Redacted_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_TicketParentID_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_TicketQuoteID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_TicketStatusID_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_TicketTemplateID_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([ix_Ticket_TicketType2IDTitle_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_Title]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_VerifierUserID_IsVerified_TicketStatusID_Inc_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] 
([IX_TicketT_TicketID_ProjectID_TicketType2ID_TicketStatusID_OwnerID_AssignedToUserID_AssognedByUserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([_WA_Sys_0000003F_26A5A303]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([_WA_Sys_0000003E_26A5A303]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([_WA_Sys_00000043_26A5A303]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([_WA_Sys_0000003D_26A5A303]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([_WA_Sys_0000003C_26A5A303]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([_WA_Sys_00000016_26A5A303]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([_WA_Sys_00000009_26A5A303]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([_WA_Sys_0000001F_26A5A303]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([_WA_Sys_0000001D_26A5A303]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([_WA_Sys_00000017_26A5A303]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([_WA_Sys_00000038_26A5A303]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([IX_Ticket_ProjectPhaseID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([_WA_Sys_00000045_26A5A303]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([_WA_Sys_00000010_26A5A303]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([_WA_Sys_00000011_26A5A303]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([_WA_Sys_0000000B_26A5A303]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([_WA_Sys_0000001A_26A5A303]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Ticket] ([_WA_Sys_00000015_26A5A303]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Milestone] ([PK_Milestone]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Milestone] ([_WA_Sys_00000011_26BAB19C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Milestone] ([_WA_Sys_00000004_26BAB19C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Milestone] ([_WA_Sys_00000005_26BAB19C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Milestone] ([_WA_Sys_00000003_26BAB19C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Milestone] ([_WA_Sys_00000012_26BAB19C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Milestone] ([_WA_Sys_0000000C_26BAB19C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Milestone] ([_WA_Sys_0000000D_26BAB19C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Milestone] ([_WA_Sys_00000002_26BAB19C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Milestone] ([_WA_Sys_0000000A_26BAB19C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Milestone] ([_WA_Sys_00000010_26BAB19C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantStatus] ([PK__Applican__3E803412F89ACC43]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantStatus] ([IX_ApplicantStatus_ApplicantIDCreated]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantStatus] ([IX_ApplicantStatus_ApplicantJobTypeID_inc]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[VacationNamedDate] ([UQ_VacationNamedDate_Date_Country]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[VacationNamedDate] ([PK_VacationNamedDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[VacationNamedDate] ([_WA_Sys_00000006_272FB2E8]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[VacationNamedDate] ([_WA_Sys_00000005_272FB2E8]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[VacationNamedDate] ([_WA_Sys_00000004_272FB2E8]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Charity] ([PK_Charity]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Session] ([PK_Session_1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Session] ([IX_Session_Modified_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Session] ([_WA_Sys_00000003_27CED166]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HelpTokenAcademy] ([PK_HelpContentAcademy]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScopeEntity] ([PK__ContentS__66AF41E672034003]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScopeEntity] ([IX_Academy_ContentScopeEntity_EntityType_Deleted]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScopeEntity] ([_WA_Sys_00000006_27EECCF7]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScopeEntity] ([_WA_Sys_00000008_27EECCF7]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScopeEntity] ([_WA_Sys_0000000A_27EECCF7]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScopeEntity] ([_WA_Sys_00000009_27EECCF7]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScopeEntity] ([_WA_Sys_00000003_27EECCF7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClaimUserRole] ([PK_ExpenseClaimUserRole]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectEstimateHistory] ([PK_ProjectEstimateHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataCategory] ([PK_DataCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataCategory] ([_WA_Sys_0000000A_284DF453]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataCategory] ([_WA_Sys_00000003_284DF453]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataCategory] ([_WA_Sys_00000002_284DF453]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelDestination] ([PK_TravelDestination]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelDestination] ([UQ_TravelDestination_CanLeaveBy]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelDestination] ([UQ_TravelDestination_ArrivalDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelDestination] ([IX_TravelDestination_From]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelDestination] ([IX_TravelDestination_TravelRequestID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BrandLeadSource] ([PK_BrandLeadSource]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactInterest] ([PK_CrmContactInterest]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MilestoneHistory] ([IX_MilestoneHistory_MilestoneID_MilestoneHistoryID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MilestoneHistory] ([PK_MilestoneHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MilestoneHistory] ([_WA_Sys_00000011_28A2FA0E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MilestoneHistory] ([_WA_Sys_0000000B_28A2FA0E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantStatusType] ([PK__Applican__D34CB9CF1B2871E4]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[VacationRequest] ([PK_VacationRequest]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[VacationRequest] ([IX_VacationRequest_UserID_Status_FirstDay]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CharityItem] ([PK_CharityItem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Setting] ([PK_Setting]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HelpTokenUser] ([PK_HelpTokenUser]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HelpTokenUser] ([UQ_HelpTokenUser_TokenUser]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HelpTokenUser] ([_WA_Sys_00000003_29CC2871]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HelpTokenUser] ([_WA_Sys_00000005_29CC2871]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScopeGroup] ([PK__ContentS__F2E3192C8D16FD69]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScopeGroup] ([IX_ContentScopeGroup_ContentScopeID_inc]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReportDoneItem] ([PK_DoneItem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReportDoneItem] ([IDX_UNIQUE_USER_ITEM]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClass] ([PK_ExpenseClass]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClass] ([IX_ExpenseClass_ExpenseTypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClass] ([IX_ExpenseClass_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExpense] ([PK_ProjectExpense]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExpense] ([IX_ProjectExpense_BusinessUnitBudgetID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExpense] ([IX_ProjectExpense_BusinessUnitID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExpense] ([IX_ProjectExpense_ExpenseCategoryID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExpense] ([IX_ProjectExpense_ExpenseTypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExpense] ([IX_ProjectExpense_ProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AzureSQLMaintenanceCMDQueue] ([PK__AzureSQL__3214EC276706E083]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataCategoryAggregationType] ([PK_DataCategoryAggregationType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactLeadStatus] ([PK_CrmContactLeadStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoard] ([PK__TicketBo__7A3E748FC8FED0DB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoard] ([IX_TicketBoard_ProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoard] ([_WA_Sys_00000005_2A7633E7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoard] ([_WA_Sys_0000000B_2A7633E7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoard] ([_WA_Sys_0000000A_2A7633E7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoard] ([_WA_Sys_00000009_2A7633E7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoard] ([_WA_Sys_00000006_2A7633E7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoard] ([_WA_Sys_0000000C_2A7633E7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MilestoneStatus] ([PK_MilestoneStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MilestoneStatus] ([_WA_Sys_00000006_2A8B4280]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MilestoneStatus] ([_WA_Sys_0000000A_2A8B4280]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MilestoneStatus] ([_WA_Sys_00000008_2A8B4280]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MilestoneStatus] ([_WA_Sys_00000004_2A8B4280]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MilestoneStatus] ([_WA_Sys_00000009_2A8B4280]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MilestoneStatus] ([_WA_Sys_00000002_2A8B4280]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantSurvey] ([PK__Applican__742952AA800CC7E5]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[VacationTransaction] ([PK__VacationTransaction]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OneOnOneReview] ([PK__OneOnOne__949D4A52EB0AEC70]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CharityItemDonation] ([PK_CharityItemDonation]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Site] ([PK_Site]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HelpType] ([PK_HelpType]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScopeJobType] ([PK__ContentS__5021C7E7BCA91F90]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScopeJobType] ([IX_ContentScopeJobType_ContentScopeID_inc]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReportForm] ([PK_ReportMailerForm]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClassDisable] ([PK_ExpenseClassDisable]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClassDisable] ([_WA_Sys_00000002_2BE97B0D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExtra] ([PK__ProjectE__167CD9BC4848688D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExtra] ([IX_ProjectExtra_ProjectID_ProjectExtraTypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExtra] ([_WA_Sys_00000007_2C09769E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExtra] ([_WA_Sys_00000003_2C09769E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExtra] ([_WA_Sys_00000006_2C09769E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExtra] ([_WA_Sys_00000009_2C09769E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExtra] ([_WA_Sys_00000008_2C09769E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExtra] ([_WA_Sys_00000004_2C09769E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataCategoryMeasure] ([PK_DataCategoryMeasure]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataCategoryMeasure] ([UQ_DataCategoryMeasure_DataCategoryID_DataElementValueMeasureID]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[DataCategoryMeasure] ([_WA_Sys_00000003_2C1E8537]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataCategoryMeasure] ([_WA_Sys_00000006_2C1E8537]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelerActualBooking] ([PK_TravelerActualBooking]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelerActualBooking] ([IX_TravelerActualBooking_TravelActualBookingID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelerActualBooking] ([IX_TravelerActualBooking_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactMonitor] ([PK_CrmContactMonitor]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoardList] ([PK__TicketBo__B38553204EF7281C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoardList] ([IX_TicketBoardList_TicketBoardID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoardList] ([_WA_Sys_0000000A_2C5E7C59]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoardList] ([_WA_Sys_00000007_2C5E7C59]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoardList] ([_WA_Sys_0000000B_2C5E7C59]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MobileDevice] ([PK_MobileDevice]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantSurveyDimension] ([PK__Applican__30E64960A5D152C7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Vendor] ([PK_Vendor]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OneOnOneReviewFrequency] ([PK__OneOnOne__A84293CB94DFD2A1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatComment] ([PK__ChatComm__E96E9D46657D2F06]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatComment] ([IX_ChatComment_Created]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatComment] ([IX_ChatComment_EntityType_EntityID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SiteHost] ([PK_SiteHost]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HistoryTransaction] ([PK_HistoryTransaction]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HistoryTransaction] ([IX_HistoryTransactionDateStamp]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScopeReportsTo] ([PK__ContentS__06EFF7A46F6328E1]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[ContentScopeReportsTo] ([IX_ContentScopeReportsTo_ContentScopeID_inc]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReportFormSubmission] ([PK_ReportFormSubmission]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseClassGeneralLedgerAccount] ([IX_ExpenseClassGeneralLedgerAccount]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExtraType] ([PK__ProjectE__B3D45726CB14E93F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExtraType] ([IX_ProjectExtraType_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExtraType] ([_WA_Sys_00000002_2DF1BF10]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExtraType] ([_WA_Sys_00000005_2DF1BF10]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExtraType] ([_WA_Sys_00000007_2DF1BF10]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExtraType] ([_WA_Sys_00000008_2DF1BF10]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectExtraType] ([_WA_Sys_0000000B_2DF1BF10]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataCategoryType] ([PK_DataCategoryType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataCategoryType] ([_WA_Sys_00000002_2E06CDA9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelerProfile] ([PK_TravelerProfile]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactMood] ([PK_CrmContactMood]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoardListItem] ([PK__TicketBo__C7D6E7606E6041CF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoardListItem] ([IX_TicketBoardListItem_EntityIDEntityType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoardListItem] ([IX_TicketBoardListItem_TicketBoardListID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoardListItem] ([UQ_TicketBoardListItem_TicketBoardListIDEntityIDEntityType]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoardListItem] ([_WA_Sys_00000008_2E46C4CB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoardListItem] ([_WA_Sys_0000000A_2E46C4CB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketBoardListItem] ([_WA_Sys_00000003_2E46C4CB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantSurveyWatchout] ([PK__Applican__0C6FF3E81F1336FC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseDecision] ([PK_ExpenseDecision]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseDecision] ([IX_ExpenseDecision_ExpenseChargeeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseDecision] ([IX_ExpenseDecision_ExpenseRequestID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Verb] ([PK_Verb]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OneOnOneReviewWidget] ([PK__OneOnOne__B4F9CBDDB0D60D0C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatEvent] ([PK_ChatEvent]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatEvent] ([IX_ChatEvent_EntityID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatEvent] ([_WA_Sys_00000002_2F650636]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatEvent] ([_WA_Sys_00000004_2F650636]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatEvent] ([_WA_Sys_00000005_2F650636]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatEvent] ([_WA_Sys_00000007_2F650636]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SNSMessageQueue] ([PK_SNSMessageQueue]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[HolidayPartyAttendee] ([PK_HolidayPartyAttendee]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([PK__Course__C92D7187DDFDEA1B]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([IX_Course_DeletedDate_PublishID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([IX_Course_GUID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([IX_Course_ImageAttachmentID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([IX_Course_RemovedDate]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([_WA_Sys_00000010_2F8FEEBF]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([_WA_Sys_00000014_2F8FEEBF]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([_WA_Sys_00000015_2F8FEEBF]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([_WA_Sys_00000019_2F8FEEBF]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([_WA_Sys_00000011_2F8FEEBF]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([_WA_Sys_00000012_2F8FEEBF]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([_WA_Sys_00000008_2F8FEEBF]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([_WA_Sys_0000000A_2F8FEEBF]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([_WA_Sys_00000006_2F8FEEBF]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([_WA_Sys_0000000E_2F8FEEBF]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([_WA_Sys_0000000F_2F8FEEBF]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([_WA_Sys_00000007_2F8FEEBF]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([_WA_Sys_0000001A_2F8FEEBF]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([_WA_Sys_00000002_2F8FEEBF]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([_WA_Sys_00000004_2F8FEEBF]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([_WA_Sys_00000017_2F8FEEBF]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([IX_Course_GUID2]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Course] ([_WA_Sys_0000001F_2F8FEEBF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReportFormSubmissionField] ([PK_ReportFormSubmissionField]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectFinanceSummary] ([PK_ProjectFinanceSummary]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElement] ([PK_DataElement]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElement] ([IX_DataElement_EntityTypeEntityID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElement] ([_WA_Sys_0000000E_2FEF161B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElement] ([_WA_Sys_00000003_2FEF161B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElement] ([_WA_Sys_0000000A_2FEF161B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElement] ([_WA_Sys_00000010_2FEF161B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElement] ([_WA_Sys_0000000D_2FEF161B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelerUser] ([PK_TravelerUser]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactNote] ([PK_CrmEmployeeNote]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChange] ([PK_TicketChange]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChange] ([IX_TicketChange_AssignedToUserID_HappenedOn_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChange] ([IX_TicketChange_HappenedOn]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChange] ([IX_TicketChange_TicketID_AffectedTable]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChange] ([IX_TicketChange_TicketID_HappenedOn_Inc_AssignedToUserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChange] ([IX_TicketChange_UserID_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChange] ([_WA_Sys_00000005_302F0D3D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantTest] ([PK__Applican__F69F8EE33D3DD0FE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseDecisionHistory] ([PK_ExpenseDecisionHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseDecisionHistory] ([IX_ExpenseDecisionHistory_StatusIDEffectiveExpiry]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Video] ([PK_Video]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Video] ([UQ_Video_Path]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OneOnOneWidget] ([PK__OneOnOne__378050F243319D68]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Chatter] ([PK_Chatter]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Chatter] ([IX_Chatter_Created]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Chatter] ([IX_Chatter_CreatedBy]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Chatter] ([IX_Chatter_Deleted_EntityType_Inc]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Chatter] ([IX_Chatter_EntityIDEntityType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Chatter] ([IX_Chatter_EntityType_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Chatter] ([IX_Chatter_LastActivity]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Chatter] ([_WA_Sys_00000004_314D4EA8]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Chatter] ([_WA_Sys_0000000F_314D4EA8]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Chatter] ([_WA_Sys_00000009_314D4EA8]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Chatter] ([_WA_Sys_00000003_314D4EA8]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SocialEvent] ([PK_event_event]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Idea] ([PK_Idea]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[CourseAsset] ([PK__CourseAs__64784F6CD7EB83F9]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[CourseAsset] ([IX_CourseAsset_CourseID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[CourseAsset] ([IX_CourseAsset_CourseID2]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[CourseAsset] ([IX_CourseAsset_DeletedDate_AssetID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[CourseAsset] ([_WA_Sys_0000000A_31783731]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[CourseAsset] ([_WA_Sys_0000000C_31783731]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[CourseAsset] ([_WA_Sys_0000000D_31783731]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ResetPassword] ([PK_ResetPassword]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ResetPassword] ([IX_ResetPassword]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ResetPassword] ([_WA_Sys_00000004_318D45CA]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ResetPassword] ([_WA_Sys_00000002_318D45CA]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecast] ([PK_ProjectForecast]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecast] 
([IX_ProjectForecast_IsReconciliationEffective_ReconciliationExpiry_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecast] ([IX_ProjectForecast_IsReconciliationReconciliationExpiry]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecast] ([IX_ProjectForecast_ProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecast] ([IX_ProjectForecast_ProjectIDEffective]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecast] ([IX_ProjectForecast_ProjectIDReconciliationExpiry]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecast] ([_WA_Sys_00000005_31C24FF4]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecast] ([_WA_Sys_00000004_31C24FF4]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecast] ([_WA_Sys_00000006_31C24FF4]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecast] ([_WA_Sys_00000007_31C24FF4]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementType] ([PK_DataElementType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementType] ([_WA_Sys_00000002_31D75E8D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementType] ([_WA_Sys_0000000B_31D75E8D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementType] ([_WA_Sys_00000003_31D75E8D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelExpenseCharge] ([PK_TravelExpenseCharge]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelExpenseCharge] ([IX_TravelExpenseCharge_DestinationID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelExpenseCharge] ([IX_TravelExpenseCharge_ProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactNoteAttachment] ([PK_CrmContactNoteAttachment]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChangeField] ([PK_TicketChangeField]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChangeField] ([IX_TicketChangeField_FieldName_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChangeField] 
([IX_TicketChangeField_TicketChangeID_FieldName_ValueBeforeID_ValueAfterID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChangeField] ([_WA_Sys_00000006_321755AF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChangeField] ([_WA_Sys_0000000B_321755AF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChangeField] ([_WA_Sys_0000000A_321755AF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantTestResult] ([PK__Applican__F1D02087704D71D7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseDecisionNextStatus] ([PK_ExpenseDecisionNextStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseDecisionNextStatus] ([_WA_Sys_00000002_3296789C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[VotingBallot] ([PK_VotingBallot]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Opportunity] ([PK_Opportunity]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatterGenomeMedia] ([PK_ChatterGenomeMedia]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatterGenomeMedia] ([IX_ChatterGenomeMedia_GenomeMediaID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatterGenomeMedia] ([UQ_ChatterGenomeMedia_ChatterID_GenomeMediaID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SocialEventAvailibility] ([PK_event_EventAvailibility]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ImportError] ([PK_ImportError]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([PK__Enrollme__7F6877FBF9B4F4B9]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([IX_Academy_Enrollment_DeletedDate_UserID_EnrollmentStartDate_Inc]) WITH 
FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([IX_Enrollment_DeletedDate_RegulationEnrollmentID_includes]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([IX_Enrollment_DeletedDate_RequiredDate_includes]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([IX_Enrollment_EnrollableGUID_RegulationEnrollmentID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([IX_Enrollment_EnrollmentStartDate]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([IX_Enrollment_RegulationEnrollmentID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([IX_Enrollment_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] 
([IX_Enrollment_UserID_EnrollableGUID_DeletedDate_EnrollmentStartDate_includes]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([IX_Enrollment_UserID_EnrollableGUID_EnrollmentStartDate_INC]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([IX_Enrollment_UserID_EnrollableGUID_RequiredDate_DeletedDate_INC]) WITH 
FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([IX_Enrollment_UserID_RequiredDate_EnrollableGUID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([_WA_Sys_00000003_33607FA3]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([_WA_Sys_0000000C_33607FA3]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] 
([IX_Academy_Enrollment_DeletedDate_UserID_EnrollableGUID_EnrollmentStartDate_Inc]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([IX_Academy_Enrollment_DeletedDate_UserID_EnrollableGUID_EnrollmentRankCalc]) 
WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([IX_Academy_Enrollment_DeletedDate_EnrollableGUID_RequiredDate]) WITH 
FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([_WA_Sys_0000000B_33607FA3]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([_WA_Sys_00000004_33607FA3]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([_WA_Sys_00000005_33607FA3]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([IX_Enrollment_DeletedCreatedEnrollmentDates]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([_WA_Sys_0000000D_33607FA3]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Enrollment] ([_WA_Sys_00000006_33607FA3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ResumeParsedFile] ([PK__ResumePa__447435A13CCC94F6]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecastEstimate] ([PK_ProjectForecastEstimate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecastEstimate] ([UQ_ProjectForecastEstimate_PFIDPhaseID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValue] ([PK_DataElementValue]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValue] ([UQ_DataElementValue_DataElementID_DataElementValueMeasureID_StartDate]) 
WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValue] ([IX_DataElementValue_DataElementIDMeasureIDDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValue] ([_WA_Sys_00000007_33BFA6FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValue] ([_WA_Sys_00000006_33BFA6FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValue] ([_WA_Sys_00000002_33BFA6FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValue] ([_WA_Sys_00000008_33BFA6FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValue] ([_WA_Sys_00000004_33BFA6FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValue] ([_WA_Sys_00000005_33BFA6FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValue] ([_WA_Sys_0000000D_33BFA6FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValue] ([_WA_Sys_0000000E_33BFA6FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValue] ([_WA_Sys_0000000C_33BFA6FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValue] ([_WA_Sys_0000000B_33BFA6FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValue] ([IX_DataElementValue_DataElementValueMeasureID_IsActive_Value_StartDate]) 
WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelPass] ([PK_TravelPass]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelPass] ([_WA_Sys_00000004_33CA93F7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelPass] ([_WA_Sys_00000002_33CA93F7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactPhoto] ([PK_CrmContactPhoto]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([PK__TicketCh__62A4C9D671E305EB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([IX_TicketChecklistItem_AssignedToUserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([IX_TicketCheckListItem_Completed]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([IX_TicketChecklistItem_ConvertedToTicketID_Deleted_Redacted_Inc]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([IX_TicketChecklistItem_CreatedBy_Deleted_ConvertedToTicketID_Redacted]) 
WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([IX_TicketChecklistItem_Deleted_IsComplete_AssignedToUserID_inc]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([IX_TicketChecklistItem_DueDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([IX_TicketChecklistItem_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([IX_TicketChecklistItem_TicketID_Deleted_Redacted]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([IX_TicketChecklistItem_TicketTemplateChecklistItemID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([_WA_Sys_00000015_33FF9E21]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([_WA_Sys_00000014_33FF9E21]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([_WA_Sys_0000000A_33FF9E21]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([_WA_Sys_00000011_33FF9E21]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([_WA_Sys_0000000B_33FF9E21]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([_WA_Sys_00000013_33FF9E21]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([_WA_Sys_0000000F_33FF9E21]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([_WA_Sys_00000012_33FF9E21]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([_WA_Sys_00000003_33FF9E21]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([_WA_Sys_00000019_33FF9E21]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([IX_TicketChecklistItem_Alfred]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItem] ([_WA_Sys_00000006_33FF9E21]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantTrait] ([PK__Applican__157A217CDAB103F4]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseDecisionStatus] ([PK_ExpenseDecisionStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[VotingContestant] ([PK_VotingContestant]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OpportunityBusinessGroup] ([PK_OpportunityBusinessGroup]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatterGiving] ([PK_ChatterGiving]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SocialEventImage] ([PK_event_eventImage]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Initiative] ([PK_Initiative]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Initiative] ([_WA_Sys_00000002_353DDB1D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Initiative] ([_WA_Sys_00000003_353DDB1D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Initiative] ([_WA_Sys_00000004_353DDB1D]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[EventHistory] ([PK__EventHis__6A9A0D3D12FAE02E]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[EventHistory] ([_WA_Sys_00000006_3548C815]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[EventHistory] ([_WA_Sys_00000009_3548C815]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[EventHistory] ([_WA_Sys_00000002_3548C815]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RevenueInvoice] ([PK_RevenueInvoice]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RevenueInvoice] ([IX_RevenueInvoice_Due]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityGroup] ([PK_EntityGroup]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecastEstimateExpense] ([PK_ProjectForecastEstimateExpense]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelPreferredBooking] ([IX_TravelPreferredBooking_DestinationBookingType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelPreferredBooking] ([PK_TravelPreferredBooking]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactReminder] ([PK_CrmContactReminder]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItemHistory] ([PK_TicketChecklistItemHistoryID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItemHistory] ([IX_TicketChecklistItemHistory_FieldNameDate_includes]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItemHistory] 
([IX_TicketChecklistItemHistory_TickectChecklistItemID_FieldName_UserID_ValueAfterID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItemHistory] 
([IX_TicketChecklistItemHistory_TicketChecklistItemID_Date_FieldName]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItemHistory] 
([IX_TicketChecklistItemHistory_TicketChecklistItemID_FieldName_Date_inc]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItemHistory] ([_WA_Sys_00000009_35E7E693]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItemHistory] ([_WA_Sys_00000003_35E7E693]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItemHistory] ([_WA_Sys_00000006_35E7E693]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantURL] ([PK__Applican__902306DD0B1A886E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseInvoice] ([PK_ExpenseInvoice]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseInvoice] ([IX_ExpenseInvoice_Due]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseInvoice] ([IX_ExpenseInvoice_ExpenseItemID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseInvoice] ([IX_ExpenseInvoice_PurchaseOrderID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseInvoice] ([IX_ExpenseInvoice_SupplierReference]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Webhost] ([PK_Webhost]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValueHistory] ([IX_DataElementValueHistory_DataElementID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValueHistory] ([IX_DataElementValueHistory_DataElementValueID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValueHistory] ([_WA_Sys_00000003_369C13AA]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValueHistory] ([_WA_Sys_00000005_369C13AA]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValueHistory] ([_WA_Sys_00000002_369C13AA]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OpportunityCategory] ([PK_OpportunityCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatterKudosType] ([PK_ChatterKudos]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatterKudosType] ([UQ_ChatterKudosType_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatterKudosType] ([_WA_Sys_00000009_370627FE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SocialEventInvitation] ([PK_event_EventInvitation]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[InitiativeTagCategory] ([PK_InitiativeTagCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[InitiativeTagCategory] ([UC_InitiativeTagCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[InitiativeTagCategory] ([_WA_Sys_00000003_3726238F]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Prerequisite] ([PK__Prerequi__25A953F999BD7104]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Prerequisite] ([IX_Prerequisite_RequiredGuid]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RevenueInvoiceHistory] ([PK_RevenueInvoiceHistory_1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RevenueInvoiceHistory] ([IX_RevenueInvoiceHistory_Effective_Expiry]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RevenueInvoiceHistory] ([IX_RevenueInvoiceHistory_ExpiryStatusID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RevenueInvoiceHistory] ([IX_RevenueInvoiceHistory_StatusEffectiveExpiry]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RevenueInvoiceHistory] ([IX_RevenueInvoiceHistory_StatusID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecastEstimateLabor] ([PK_ProjectForecastEstimateLabor]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValueMeasure] ([PK_DataElementValueMeasure]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValueMeasure] ([UQ_DataElementValueMeasure_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValueMeasure] ([_WA_Sys_00000005_379037E3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValueMeasure] ([_WA_Sys_00000009_379037E3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValueMeasure] ([_WA_Sys_00000007_379037E3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValueMeasure] ([_WA_Sys_0000000A_379037E3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DataElementValueMeasure] ([_WA_Sys_00000003_379037E3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelProvider] ([PK_TravelProvider]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelProvider] ([UQ_TravelProvider_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelProvider] ([IX_TravelProvider_City]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelProvider] ([IX_TravelProvider_StateProvince]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelProvider] ([_WA_Sys_00000008_379B24DB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelProvider] ([_WA_Sys_00000002_379B24DB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactReview] ([PK_CrmContactReview]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactReview] ([IX_CrmContactReview]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItemTokenValue] ([PK_TicketChecklistItemTokenValue]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItemTokenValue] 
([IX_TicketChecklistItemTokenValue_TicketChecklistItemID_TicketTemplateTokenID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChecklistItemTokenValue] ([_WA_Sys_00000003_37D02F05]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MultiPartUpload] ([PK_MultiPartUpload]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MultiPartUpload] ([IX_MultiPartUpload_EntityType_EntityID_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MultiPartUpload] ([_WA_Sys_00000011_37E53D9E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MultiPartUpload] ([_WA_Sys_00000002_37E53D9E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MultiPartUpload] ([_WA_Sys_00000004_37E53D9E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MultiPartUpload] ([_WA_Sys_00000012_37E53D9E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MultiPartUpload] ([_WA_Sys_0000000A_37E53D9E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantUser] ([PK__Applican__FBEF2E4600B85D98]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantUser] ([IX_ApplicantUser_ApplicantID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantUser] ([IX_ApplicantUser_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantUser] ([UQ_ApplicantUser_ApplicantIDType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleSuperCache] ([IX_RoleSuperCache_SuperRoleID_RoleID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleSuperCache] ([IX_RoleSuperCache_RoleID_SuperRoleID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseInvoiceNextStatus] ([PK_ExpenseInvoiceNextStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WebserviceBan] ([PK__Webservi__79EB07CFD4859032]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WebserviceBan] ([IX_WebserviceBan_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OpportunityCategoryType] ([PK_OpportunityCategoryType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OpportunityCategoryType] ([_WA_Sys_00000004_38A457AD]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OpportunityCategoryType] ([_WA_Sys_00000006_38A457AD]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatterTag] ([PK_ChatterTag]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatterTag] ([IX_ChatterTag_AccountPortfolioID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatterTag] ([IX_ChatterTag_CompanyID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatterTag] ([IX_ChatterTag_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ChatterTag] ([UQ_ChatterTag_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SocialEventOption] ([PK_event_eventDate]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Publish] ([PK__Publish__C259F133C3AA1CD7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RevenueInvoiceNextStatus] ([PK_RevenueInvoiceNextStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RevenueInvoiceNextStatus] ([_WA_Sys_00000002_392E6792]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecastExpense] ([PK_ProjectForecastExpense]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecastExpense] ([IX_ProjectForecastExpense_ProjectForecastID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactReviewConcern] ([PK_CrmContactReviewConcern]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketClientStatus] ([PK_TicketClientStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketClientStatus] ([_WA_Sys_00000002_39B87777]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MultiPartUploadPart] ([PK_MultiPartUploadPart]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MultiPartUploadPart] ([_WA_Sys_00000002_39CD8610]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MultiPartUploadPart] ([_WA_Sys_00000006_39CD8610]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[InitiativeType] ([PK_InitiativeType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[InitiativeType] ([_WA_Sys_00000007_3A02903A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[InitiativeType] ([_WA_Sys_00000002_3A02903A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantWatchout] ([PK__Applican__D20410E31C50A525]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantWatchout] ([_WA_Sys_00000004_3A179ED3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantWatchout] ([_WA_Sys_00000006_3A179ED3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseInvoiceStatus] ([PK_ExpenseInvoiceStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WebservicePermission] ([PK_WebservicePermission]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WebservicePermission] ([IX_WebservicePermission_AuthTokenID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WebservicePermission] ([IX_WebservicePermission_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelRequest] ([PK_TravelRequest]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OpportunityHistory] ([PK_OpportunityHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[City] ([PK_City]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[City] ([UQ_City_CountryIDName]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[StageGate] ([PK_StageGate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[StageGate] ([_WA_Sys_0000000C_3AE1A5DA]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[StageGate] ([_WA_Sys_00000002_3AE1A5DA]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[StageGate] ([_WA_Sys_00000006_3AE1A5DA]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[StageGate] ([_WA_Sys_00000007_3AE1A5DA]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Question] ([PK__Question__0DC06F8CC8C2FE9D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RevenueInvoicePartnerFeeRebate] ([PK_RevenueInvoicePartnerFeeRebate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RevenueInvoicePartnerFeeRebate] ([UQ_RevenueInvoicePartnerFeeRebate_BillingItemID]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecastLabor] ([PK_ProjectForecastLabor]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecastLabor] ([IX_ProjectForecastLabor_LaborRoleID_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecastLabor] ([IX_ProjectForecastLabor_ProjectForecastID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactType] ([PK_CrmContactType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketComment] ([PK_TicketComment]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketComment] ([IX_PostedEmployeeID_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketComment] ([IX_TicketComment_ClientCanViewCreated_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketComment] ([IX_TicketComment_Created]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketComment] ([IX_TicketComment_PostedEmployeeID_Created]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketComment] ([IX_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketComment] ([_WA_Sys_0000000B_3BA0BFE9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketComment] ([_WA_Sys_00000008_3BA0BFE9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[MyProjects] ([PK_MyProjects]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[InstantMessage] ([PK_InstantMessage]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApplicantWatchoutJobType] ([PK_ApplicantWatchoutJobType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseItem] ([PK_ExpenseItem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseItem] ([IX_ExpenseItem_CategoryPO]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseItem] ([IX_ExpenseItem_ExpenseRequestID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseItem] ([IX_ExpenseItem_PayeeSupplierID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WebserviceRequest] ([PK__Webservi__2AB4D6CFF4EFF75C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WebserviceRequest] ([IX_WebserviceRequest_UserIDDate_include]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WebserviceRequest] ([_WA_Sys_00000004_3C2ACFCE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WebserviceRequest] ([_WA_Sys_00000003_3C2ACFCE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WebserviceRequest] ([_WA_Sys_00000006_3C2ACFCE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityGroupDefinition] ([PK_EntityGroupDefinition]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelRequestHistory] ([PK_TravelRequestHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelRequestHistory] ([IX_TravelRequestHistory_EffectiveExpiry]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelRequestHistory] ([IX_TravelRequestHistory_StatusID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OpportunityMilestone] ([PK_OpportunityMilestone]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[StageGateSet] ([PK_StageGateSet]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[StageGateSet] ([_WA_Sys_00000009_3CC9EE4C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[StageGateSet] ([_WA_Sys_00000004_3CC9EE4C]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[QuestionRecipient] ([PK__Question__E515D3137F8E00FE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectForecastOverhead] ([PK_ProjectForecastOverhead]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Department] ([PK_Department]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Department] ([_WA_Sys_00000007_3D491139]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Department] ([_WA_Sys_00000002_3D491139]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactUpdate] ([PK_CrmContactUpdate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactUpdate] ([IX_CrmContactUpdate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactUpdate] ([IX_CrmContactUpdate_1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmContactUpdate] ([IX_CrmContactUpdate_2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketCommentHistory] ([PK_TicketCommentHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketCommentHistory] ([IX_TicketCommentHistory_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NewsArticle] ([PK_NewsArticle]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NewsArticle] ([IX_NewsArticle_IsLive_IsReleaseUpdate_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NewsArticle] ([IX_NewsArticle_IsLive_NewsType_StartDate_EventDate_EventEndDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NewsArticle] ([IX_NewsArticle_IsLive_Posted]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NewsArticle] ([IX_NewsArticle_IsLive_StartDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NewsArticle] ([IX_NewsArticle_IsLive_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Client] ([PK_Client]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[InteractiveScreenConfig] ([PK_InteractiveScreenConfig]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApprovalStatus] ([PK_ApprovalStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApprovalStatus] ([IX_ApprovalStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ApprovalStatus] ([IX_ApprovalStatusCreatedBy]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RevenueInvoiceStatus] ([PK_RevenueInvoiceStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseItemCharge] ([PK_ExpenseItemCharge]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseItemCharge] ([IX_ExpenseItemCharge_ExpenseDecisionID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseItemCharge] ([IX_ExpenseItemCharge_ExpenseItemID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseItemCharge] ([IX_ExpenseItemCharge_ProjectExpenseID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Wiki] ([PK_Wiki]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelRequestNextStatus] ([PK_TravelRequestNextStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelRequestNextStatus] ([_WA_Sys_00000002_3E48226A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OpportunityNextStatus] ([PK_OpportunityNextStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[StateProvince] ([PK_StateProvince]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[StateProvince] ([_WA_Sys_00000002_3EB236BE]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Regulation] ([PK_AcademyRegulation]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectGeneSequencePhase] ([PK_ProjectGeneSequencePhase]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectGeneSequencePhase] ([IX_ProjectGeneSequencePhase]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmCountry] ([PK_CrmCountry]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketDeadlineStatus] ([IX_TicketDeadlineStatus_TicketChangeFieldID_Deadline]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketDeadlineStatus] ([IX_TicketDeadlineStatus_TicketChecklistItemHistoryID_Deadline]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[NewsArticleBusinessUnit] ([PK_NewsArticleBusinessUnit]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ClientFeedback] ([PK_ClientFeedback]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[InteractiveScreenDevice] ([PK_InteractiveScreenDevice]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AppVersion] ([PK_AppVersion]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AppVersion] ([IX_AppVersion_App]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Review] ([PK_PeriodicReview]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Review] ([IX_Review_Created]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Review] ([IX_Review_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseItemFeed] ([PK_ExpenseItemFeed]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Device] ([PK_Device]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelRequestStatus] ([PK_TravelRequestStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelRequestStatus] ([_WA_Sys_00000006_40306ADC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OpportunityPursuit] ([PK_OpportunityPursuit]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Statistic] ([PK__Statisti__367DEB37E4C19A50]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Statistic] ([_WA_Sys_00000005_409A7F30]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Statistic] ([_WA_Sys_00000004_409A7F30]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[RegulationEnrollment] ([PK_AcademyRegulationEnrollment]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WikiHistory] ([IX_WikiHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmDepartment] ([PK_CrmDepartment_1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketDeadlineStatus3] ([PK_TicketDeadlineStatus3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketDeadlineStatus3] ([IX_TicketDeadlineStatus3_TicketChecklistItemID_Deadline_inc]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[TicketDeadlineStatus3] ([IX_TicketDeadlineStatus3_TicketID_Deadline_inc]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NewsArticleHeadImageSize] ([PK__NewsArti__3AD3A40BE5F833FC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ClientReview] ([PK_ClientReview]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[InteractiveScreenSchedule] ([PK_InteractiveScreenSchedule]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DateDimension] ([PK_DateDimension]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Attachment] ([PK_Attachment]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Attachment] ([IX_Attachemnt_Guid]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Attachment] ([IX_Attachment_AttachmentID_INC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Attachment] ([IX_Attachment_EntityID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Attachment] ([IX_Attachment_EntityType_Deleted_includes2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Attachment] ([IX_Attachment_EntityType_EntityID_Deleted_inc]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Attachment] ([IX_Attachment_EntityType_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Attachment] ([IX_Attachment_FileNameExt]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Attachment] ([_WA_Sys_0000000E_41B8C09B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Attachment] ([_WA_Sys_0000000D_41B8C09B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Attachment] ([_WA_Sys_00000009_41B8C09B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Attachment] ([_WA_Sys_00000007_41B8C09B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Attachment] ([_WA_Sys_0000000C_41B8C09B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Attachment] ([IX_Attachment_Deleted_EntityType_EntityID_Include]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Attachment] ([_WA_Sys_00000012_41B8C09B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewConcern] ([PK_ReviewConcern]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewConcern] ([_WA_Sys_00000004_41C3AD93]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewConcern] ([_WA_Sys_00000002_41C3AD93]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseItemFeedMerchant] ([PK_ExpenseItemFeedMerchant]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkHistory] ([PK__WorkHist__9C9E690D204F4FA0]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectGeneSequencePhaseItem] ([PK_ProjectGeneSequencePhaseItem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectGeneSequencePhaseItem] ([IX_ProjectGeneSequencePhaseItem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectGeneSequencePhaseItem] ([IX_ProjectGeneSequencePhaseItem_ProjectID_UpdatedBy]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[DeviceAuthToken] ([PK_DeviceAuthToken]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelRole] ([PK_TravelRole]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OpportunityPursuitType] ([PK_OpportunityPursuitType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[StatusReport] ([PK_StatusReport]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[RegulationPredicate] ([PK_AcademyRegulationPredicate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailAttachmentCrmEmailAttribute] ([PK_CrmEmailAttachmentCrmEmailAttachmentAttribute]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailAttachmentCrmEmailAttribute] ([UQ_CrmEmailAttachmentCrmEmailAttribute]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketGrid] ([PK_TicketGrid]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketGrid] ([IX_TicketGrid_UserIDNameValue]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NewsArticleJobType] ([PK_NewsArticleJobType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSMediaRedirect] ([PK_CMSMediaRedirect]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[InteractiveScreenView] ([PK_InteractiveScreenView]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AttachmentThumbnail] ([PK__Attachme__0111E12BD52FE7CF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AttachmentThumbnail] ([IX_AttachmentThumbnail_AttachmentID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AttachmentThumbnail] ([IX_AttachmentThumbnail_FullSizeAttachmentID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AttachmentThumbnail] ([_WA_Sys_00000004_43A1090D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewConcernByEntity] ([PK_ReviewConcernByEntity]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewConcernByEntity] ([_WA_Sys_00000004_43ABF605]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewConcernByEntity] ([_WA_Sys_00000003_43ABF605]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewConcernByEntity] ([_WA_Sys_00000002_43ABF605]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseRequest] ([PK_ExpenseRequest]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseRequest] ([IX_ExpenseRequest_CreditExpenseItemID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseRequest] ([IX_ExpenseRequest_PayeeSupplierID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseRequest] ([IX_ExpenseRequest_SupplierRefNo]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrder] ([PK_WorkOrder]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrder] ([IX_WorkflowTicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrder] ([IX_WorkOrder_BillingTypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrder] ([IX_WorkOrder_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrder] ([IX_WorkOrder_ProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrder] ([IX_WorkOrder_TypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrder] ([IX_WorkOrder_VersionID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserDefaultPhotoCache] ([PK_UserDefaultPhotoCache]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserDefaultPhotoCache] ([_WA_Sys_00000002_43CD8844]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserDefaultPhotoCache] ([_WA_Sys_00000003_43CD8844]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserDefaultPhotoCache] ([_WA_Sys_00000004_43CD8844]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelUser] ([PK_TravelUser]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OpportunityStatus] ([PK_OpportunityStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[StatusReportAttachment] ([PK_Table1]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Specialization] ([PK__Speciali__5809D84F36642F1F]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Specialization] ([IX_Specialization_GUID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Specialization] ([IX_Specialization_GUID2]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Specialization] ([IX_Specialization_ImageAttachmentID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectInvoice] ([PK_ProjectInvoice]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Document] ([PK_Document]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailAttachmentCrmEmailCategory] ([PK_CrmEmailAttachmentCrmEmailAttachmentCategory_1]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailAttachmentCrmEmailCategory] ([UQ_CrmEmailAttachmentCrmEmailCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketGridSetting] ([PK_TicketGridSetting]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NewsArticleScope] ([PK_NewsArticleScope]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSPage] ([PK_CMSPage]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSPage] ([_WA_Sys_00000002_45544755]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSPage] ([_WA_Sys_00000009_45544755]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSPage] ([_WA_Sys_00000003_45544755]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Inventory] ([PK_Inventory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Inventory] ([_WA_Sys_00000002_457442E6]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AttachmentTranscoded] ([PK_AttachmentTranscoded]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AttachmentTranscoded] ([IX_AttachmentTranscoded_AttachmentID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewInsight] ([PK_ReviewInsight]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewInsight] ([IX_ReviewInsight_EntityID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewInsight] ([IX_ReviewInsight_ReviewID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewInsight] ([IX_ReviewInsight_ReviewQuestionID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewInsight] ([IX_ReviewInsight_SubEntityID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseRequestHistory] ([PK_ExpenseRequestHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderAllotment] ([PK_WorkOrderAllotment]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelUserPreference] ([PK_TravelUserPreference]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelUserPreference] ([IX_TravelUserPreference_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelUserPreference] ([UQ_TravelUserPreference]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OpportunityTag] ([PK_OpportunityTag]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateTokenCondition] ([PK_TicketTemplateTokenCondition]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[StoryUser] ([PK_StoryUser]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[SpecializationCourse] ([PK__Speciali__8E4460E3AB4470C1]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[SpecializationCourse] ([IX_SpecializationCourse_CourseID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[SpecializationCourse] ([IX_SpecializationCourse_SpecializationID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectInvoiceType] ([PK_ProjectInvoiceType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DocumentFile] ([PK_DocumentFile]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailAttachmentCrmEmailRating] ([PK_CrmEmailAttachmentCrmEmailAttachmentRating]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailAttachmentCrmEmailRating] ([UQ_CrmEmailAttachmentCrmEmailRating]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketGridSettingValue] ([PK_TicketGridSettingValue]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NewsArticleScopeGroup] ([PK_NewsArticleScopeGroup]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSPageVersion] ([PK_CMSPageVersion]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSPageVersion] ([_WA_Sys_00000002_473C8FC7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSPageVersion] ([_WA_Sys_00000003_473C8FC7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSPageVersion] ([_WA_Sys_00000006_473C8FC7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSPageVersion] ([_WA_Sys_0000000C_473C8FC7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSPageVersion] ([_WA_Sys_00000004_473C8FC7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSPageVersion] ([_WA_Sys_00000005_473C8FC7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[IPAddress] ([PK_IPAddress]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AttachmentVariation] ([PK_AttachmentVariation]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AttachmentVariation] ([IX_AttachmentVariation_AttachmentID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewInsightType] ([PK_GenomeInsight]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewInsightType] ([_WA_Sys_00000002_477C86E9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseRequestStatus] ([PK_ExpenseRequestStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderAllotmentFund] ([PK_WorkOrderAllotmentFund]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderAllotmentFund] ([IX_WorkOrderAllotmentFund_WorkOrderID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderAllotmentFund] ([IX_WorkOrderAllotmentFund_WorkOrderIDAmount]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelUserRole] ([UQ_TravelUserRole]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelUserRole] ([PK_TravelUserRole]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TravelUserRole] ([IX_TravelUserRole_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OrgChart] ([PK_OrgChart]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Subscription] ([PK_UserNotification]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Subscription] ([IX_Subscription_NameSubscriberSubscribeTo]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Subscription] ([IX_Subscription_status]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Subscription] ([IX_Subscription_SubscriberUserID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([PK__StatusHi__DB9734B164C12587]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([IX_academy_StatusHistory_UserID_IsContextSpecificStatus_inc]) WITH 
FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([IX_StatusHistory_UserID_EntityType_inc]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([IX_StatusHistory_UserID_NewThingGuid_CreatedDate_StatusHistoryID]) WITH 
FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([_WA_Sys_00000010_485B9C89]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([IX_StatusHistory_UserID_Status_EntityType_inc]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([_WA_Sys_00000005_485B9C89]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([_WA_Sys_0000000D_485B9C89]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([_WA_Sys_0000000C_485B9C89]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([_WA_Sys_00000006_485B9C89]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] 
([IX_StatusHistory_UserID_NewThingGuid_NewCourseGUID_CreatedDate_StatusHistoryID_INC]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([IX_StatusHistory_NewThingGuid_INC]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([_WA_Sys_0000000F_485B9C89]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([_WA_Sys_00000008_485B9C89]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([_WA_Sys_00000009_485B9C89]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([_WA_Sys_0000000B_485B9C89]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([_WA_Sys_00000002_485B9C89]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([_WA_Sys_00000003_485B9C89]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[StatusHistory] ([IX_StatusHistory_Filtered_IsLatest]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectLeadHistory] ([PK_ProjectLeadHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectLeadHistory] ([_WA_Sys_00000002_48A5B54C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectLeadHistory] ([_WA_Sys_00000005_48A5B54C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectLeadHistory] ([_WA_Sys_00000003_48A5B54C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectLeadHistory] ([_WA_Sys_00000004_48A5B54C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectLeadHistory] ([_WA_Sys_00000006_48A5B54C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DocumentFolder] ([PK_DocumentFolder]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailAttribute] ([PK_CrmEmailAttribute]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketLaborRole] ([PK__TicketLa__7649ABAE1F7FB369]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketLaborRole] ([_WA_Sys_00000002_48FABB07]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NewsArticleUser] ([PK_NewsArticleUser]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NewsArticleUser] ([IX_NewsArticleUser_UserID_NewsArticleID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NewsArticleUser] ([IX_NewsArticleUser_Viewed]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSPageVersionValue] ([PK_CMSPageVersionValue]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSPageVersionValue] ([_WA_Sys_00000002_4924D839]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[JobDescription] ([PK_JobDescription]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Audit] ([_WA_Sys_00000001_4959E263]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Audit] ([_WA_Sys_00000002_4959E263]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Audit] ([_WA_Sys_00000003_4959E263]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Audit] ([_WA_Sys_00000007_4959E263]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Audit] ([IX_Audit_Table_Schema]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewOpportunity] ([PK_ReviewOpportunity]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewOpportunity] ([UQ_ReviewOpportunity]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExpenseType] ([PK_ExpenseType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderAllotmentType] ([PK_WorkOrderAllotmentType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderAllotmentType] ([_WA_Sys_00000002_4984CAEC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OutOfOffice] ([PK__OutOfOff__A4AF36F16A53F73E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OutOfOffice] ([IX_OutOfOffice_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Subsidiary] ([PK_Subsidiary]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Subsidiary] ([_WA_Sys_0000000D_4A23E96A]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[TranscriptEntry] ([PK_TranscriptEntry]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[TranscriptEntry] ([IX_academyTranscriptEntry_DeletedDate_CompletiondID_inc]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[TranscriptEntry] ([IX_TranscriptEntry_AssessmentResultID]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[TranscriptEntry] ([IX_TranscriptEntry_EnrollmentNotification]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[TranscriptEntry] ([IX_TranscriptEntry_ForCompletionReport]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[TranscriptEntry] ([IX_TranscriptEntry_Type_Status_includes]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[TranscriptEntry] ([_WA_Sys_00000006_4A43E4FB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectLink] ([PK_ProjectLink]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DocumentSign] ([PK_DocumentSign]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DocumentSign] ([IX_DocumentSign]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DocumentSign] ([IX_DocumentSign_EnvelopeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UrlRewrite] ([PK_UrlRewrite]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UrlRewrite] ([IX_UrlRewrite_Token]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStageGateHistory] ([_WA_Sys_00000006_4AD056E5]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStageGateHistory] ([_WA_Sys_00000005_4AD056E5]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailCategory] ([PK_CrmEmailLogCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketList] ([PK_TicketList]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketList] ([IX_TicketList]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NewsDepartment] ([PK_NewsDepartment]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NewsDepartment] ([IX_NewsDepartment_LaborRoleID_NewsArticleID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSTemplate] ([PK_CMSTemplate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSTemplate] ([_WA_Sys_00000008_4B0D20AB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSTemplate] ([_WA_Sys_00000002_4B0D20AB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[JobDescriptionApplicantLocation] ([PK_JobDescriptionApplicantLocation]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewPortfolio] ([PK_ReviewPortfolio]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewPortfolio] ([UQ_ReviewPortfolio]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExternalUserGroup] ([PK_ExternalUserGroup]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderBillingFrequency] ([PK_WorkOrderBillingFrequency]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountingFeed] ([PK_AccountingFeed]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountingFeed] ([IX_AccountingFeed_FeedTypeRefNo1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OutOfPocketExpense] ([PK_OutOfPocketExpense]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OutOfPocketExpense] ([IX_OutOfPocketExpense]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SubsidiaryCurrency] ([PK_SubsidiaryCurrency]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[UserBadge] ([PK__UserBadg__11D3ACBFE1D1AAD5]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AuthToken] ([PK_AuthToken]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AuthToken] ([IX_AuthToken_ExpireDate_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AuthToken] ([UQ_AuthToken_Token]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AuthToken] ([_WA_Sys_00000003_4C364F0E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AuthToken] ([_WA_Sys_00000005_4C364F0E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectLockdown] ([PK_ProjectLockdown]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DocumentTemplate] ([PK_DocumentTemplate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([PK_User]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([IX_firstname]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([IX_User_Enabled_Hidden_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([IX_User_Enabled_Hidden_L_R]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([IX_User_Enabled_L_R_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([IX_User_EnabledUsername_LaborRoleID_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([IX_User_L]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([IX_User_R]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([IX_User_SupervisorID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([IX_User_SystemID_Enabled_IsBookable]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([IX_User_Username_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([IX_User_UserSystemID_Enabled_IsScheduleConfirmationRulesEnforcedCreatedDate_includes]) 
WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([IX_User_UserSystemID_Enabled_LaborRoleID_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([IX_User_UserSystemID_INC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([IX_WorkTeam]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_00000011_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([UQ_User_SystemIDLoginName]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_00000048_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_00000009_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_0000003D_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_00000024_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_00000012_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_00000013_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_00000040_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_0000002F_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_00000032_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_00000020_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_0000000A_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_0000003E_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_00000043_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_00000039_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_00000006_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([IX_User_UserSysetmID_Enabled_Hidden_Inc]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_00000008_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_00000019_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_00000018_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_0000000C_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User] ([_WA_Sys_0000004B_4C9641C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailCrmEmailAttribute] ([UQ_CrmEmailCrmEmailAttribute]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketListTicket] ([PK_TicketListTicket]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketListTicket] ([IX_TicketListTicket]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NewsPortfolio] ([PK_NewsPortfolio]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CMSTemplateToken] ([PK_CMSTemplateToken]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[JobDescriptionVendor] ([PK_JobDescriptionVendor]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewProject] ([PK_ReviewProject]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewProject] ([IX_ReviewProject_ProjectBudgetID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewProject] ([IX_ReviewProject_ProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewProject] ([IX_ReviewProject_ReviewID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExternalUserGroupProject] ([PK_ExternalUserGroupProject]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderBillingType] ([PK_WorkOrderBillingType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountingReplicationLog] ([PK_AccountingReplicationLog]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountingReplicationLog] ([IX_AccountingReplicationLog_EntityTypeEntityIDSeverityIDCreated]) 
WITH FULLSCAN;
UPDATE STATISTICS [dbo].[OverheadType] ([PK_OverheadType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailCrmEmailCategory] ([PK_CrmEmailCrmEmailCategory_1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailCrmEmailCategory] ([UQ_CrmEmailCrmEmailCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SubsidiaryCurrencyBank] ([PK_SubsidiaryCurrencyBank]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BBCode] ([PK_BBCode]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectMilestone] ([PK_ProjectMilestone]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DocumentTemplateGeneratedDocument] ([PK_DocumentTemplateGeneratedDocument]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DocumentTemplateGeneratedDocument] ([IX_DocumentTemplateGeneratedDocument]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User360NotificationRule] ([PK_User360NotificationRule]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[User360NotificationRule] ([IX_User360NotificationRule_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketPriority] ([PK_TicketPriority]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Note] ([PK_Note]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Company] ([PK_Company]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Company] ([IX_CrmCompany]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Company] ([IX_Company_CompanyID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Company] ([UQ_Company_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Company] ([_WA_Sys_00000012_4EDDB18F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Company] ([_WA_Sys_0000000F_4EDDB18F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Company] ([_WA_Sys_00000006_4EDDB18F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[JobTitleType] ([PK_JobTitleType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[JobTitleType] ([_WA_Sys_00000005_4EFDAD20]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[JobTitleType] ([_WA_Sys_00000007_4EFDAD20]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewQuestion] ([PK_ReviewQuestion]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewQuestion] ([IX_ReviewQuestion_ReviewID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExternalUserGroupUser] ([PK_ExternalUserGroupUser]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderContract] ([PK_WorkOrderContract]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderContract] ([IX_WorkOrderContract_ProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderContract] ([IX_WorkOrderContract_WorkOrderHistoryID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderContract] ([IX_WorkOrderContract_WorkOrderTypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderContract] ([IX_WorkOrderContract_WorkOrderVersionID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolio] ([PK_AccountPortfolio]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolio] ([UQ_AccountPortfolio_CompanyIDName]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolio] ([_WA_Sys_00000007_4F47C5E3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolio] ([IX_AccountPortfolio_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolio] ([IX_AcountPortfolio_AccountPortfolioID_ClientCompanyID_INC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolio] ([_WA_Sys_0000000C_4F47C5E3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolio] ([_WA_Sys_0000000A_4F47C5E3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolio] ([_WA_Sys_00000009_4F47C5E3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolio] ([_WA_Sys_0000000D_4F47C5E3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PageNote] ([PK_PageNote]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PageNote] ([IX_PageNote_DateCreated]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PageNote] ([IX_PageNote_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailCrmEmailRating] ([PK_CrmEmailCrmEmailRating]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailCrmEmailRating] ([UQ_CrmEmailCrmEmailRating]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Suggestion] ([PK_Suggestion_ID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BillingItem] ([PK_BillingItem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BillingItem] ([IX_BillingItem_AccountingRefNo]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BillingItem] ([IX_BillingItem_AccountingSeqNo]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BillingItem] ([IX_BillingItem_BillingDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BillingItem] ([IX_BillingItem_WorkflowTicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectMilestoneHistory] ([PK_ProjectMilestoneHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DocumentTemplateGlobalTokenValue] ([PK_DocumentTemplateGlobalTokenValue]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DocumentTemplateGlobalTokenValue] ([IX_DocumentTemplateGlobalTokenValue]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserAccessFileSystemCache] ([IX_UserAccessFileSystemCache_AccountPortfolioID_UserID_inc]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[TicketQueue] ([PK_TicketQueue]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketQueue] ([_WA_Sys_00000003_509BDCCF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketQueue] ([_WA_Sys_00000002_509BDCCF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketQueue] ([_WA_Sys_00000004_509BDCCF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketQueue] ([_WA_Sys_00000005_509BDCCF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketQueue] ([IX_TicketQueue_IsEnabled_QueueID_Alfred]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketQueue] ([_WA_Sys_00000006_509BDCCF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketQueue] ([_WA_Sys_00000007_509BDCCF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Notification] ([PK_Notification]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Notification] ([IX_EventTypeObject_PK]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Notification] ([IX_Notification_EventTypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Notification] ([IX_Notification_EventTypeObject]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Notification] ([IX_NotificationGroupID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[JobType] ([PK_JobType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[JobType] ([UQ_Name_JobTypeCategoryID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[JobType] ([_WA_Sys_0000000A_50E5F592]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[JobType] ([_WA_Sys_00000003_50E5F592]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewQuestionType] ([PK_ReviewQuestionType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewQuestionType] ([IX_ReviewQuestionType_Sequence]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewQuestionType] ([_WA_Sys_00000011_5105F123]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewQuestionType] ([_WA_Sys_00000003_5105F123]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ExternalUserGroupWorkOrder] ([PK_ExternalUserGroupWorkOrder]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderHistory] ([PK_WorkOrderHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderHistory] ([IX_WorkOrderHistory_EffectiveExpiryStatusID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderHistory] ([IX_WorkOrderHistory_OPExpiry]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderHistory] ([IX_WorkOrderHistory_WorkOrderID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderHistory] ([IX_WorkOrderHistory_WorkOrderIDEffective]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderHistory] ([IX_WorkOrderHistory_WorkOrderIDStatusID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PagesToReload] ([PK_PagesToReload]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailLog] ([PK_CRMEmailLog]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailLog] ([IX_CrmEmailLog_GmailID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailLog] ([IX_CrmEmailLog_MailDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailLog] ([IX_CrmEmailLog_Subject]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailLog] ([IX_CrmEmailLog_ThreadSubject]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CompanyAddress] ([PK_CompanyAddress]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CompanyAddress] ([UQ_CompanyAddress_CompanyIDName]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CompanyAddress] ([_WA_Sys_00000004_51BA1E3A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CompanyAddress] ([_WA_Sys_0000000B_51BA1E3A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CompanyAddress] ([_WA_Sys_00000008_51BA1E3A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CompanyAddress] ([_WA_Sys_00000009_51BA1E3A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CompanyAddress] ([_WA_Sys_0000000A_51BA1E3A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CompanyAddress] ([_WA_Sys_0000000D_51BA1E3A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CompanyAddress] ([_WA_Sys_0000000C_51BA1E3A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Supplier] ([PK_Supplier]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Supplier] ([UQ_Supplier_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Supplier] ([IX_Supplier_ExpenseChargeeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Supplier] ([IX_Supplier_LegalName]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BillingItemContent] ([PK_BillingItemContent]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioArtifact] ([PK_AccountPortfolioArtifact]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioArtifact] ([UQ_AccountPortfolioArtifact_APIDArtifactTypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectMPPMilestone] ([PK_ProjectMPPMilestone]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DocumentTemplateToken] ([PK_DocumentTemplateToken]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserAttachment] ([PK_UserAttachment]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketQuote] ([PK_TicketQuote]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationAlertType] ([PK_NotificationAlertType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationAlertType] ([_WA_Sys_00000002_529933DA]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationAlertType] ([_WA_Sys_00000004_529933DA]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewSection] ([PK_ReviewSection]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderNextStatus] ([PK_WorkOrderNextStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderNextStatus] ([_WA_Sys_00000002_530E3526]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PathVariable] ([PK_PathVariable]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailLogCrmContact] ([PK_CRMEmailLogCRMContact]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailLogCrmContact] ([IX_CrmEmailLogCrmContact_ContactID_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CompanyDomainName] ([PK_CompanyDomainName]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[JobTypeCategory] ([PK_JobTypeCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[JobTypeCategory] ([UQ_Name_BusinessUnitID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[JobTypeCategory] ([_WA_Sys_00000003_53C2623D]) WITH FULLSCAN;
UPDATE STATISTICS [synapse].[AwardType] ([PK_AwardType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BillingItemContentVersion] ([PK_BillingItemContentVersion]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BillingItemContentVersion] ([UQ_BillingItemContentVersion_BillingItemIDEffective]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioArtifactFile] ([PK_AccountPortfolioArtifactFile]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectOverhead] ([PK_ProjectOverhead]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectOverhead] ([UQ_ProjectOverheadProjectIDOverheadTypeIDLaborRoleIDEffective]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectOverhead] 
([IX_ProjectOverhead_LaborRoleID_Rate_ProjectID_Effective_Inc_Expiry_ProjectOverheadID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DocumentTemplateTokenValue] ([PK_DocumentTemplateTokenValue]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserAway] ([PK_UserAway]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserAway] ([IX_UserAway_BackOn]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketQuoteXml] ([PK_TicketQuoteXml]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationBackup] ([PK_NotificationTypeBackup]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SupplierDocument] ([PK_SupplierDocument]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewStatus] ([PK_ReviewStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FaceGameGuess] ([PK_FaceGameGuess]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderStatus] ([PK_WorkOrderStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EndorsementRequest] ([PK_EndorsementRequest]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EndorsementRequest] ([UC_EndorsementRequest]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PaymentTemplate] ([PK_PaymentTemplate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailLogProcessingQueue] ([PK_CrmEmailLogProcessingQueue]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketSeverity] ([PK_TicketSeverity]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketSeverity] ([_WA_Sys_00000002_556091EC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketSeverity] ([_WA_Sys_00000005_556091EC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketSeverity] ([_WA_Sys_00000003_556091EC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CompanyExtra] ([PK_CompanyExtra]) WITH FULLSCAN;
UPDATE STATISTICS [synapse].[PVAward] ([PK_PVAward]) WITH FULLSCAN;
UPDATE STATISTICS [synapse].[PVAward] ([IX_PVAward]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BillingItemDocTemplate] ([PK_BillingDocTemplate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioArtifactRevision] ([PK_AccountPortfolioArtifactRevision]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioArtifactRevision] ([UQ_AccountPortfolioArtifactRevision_ArtifactIDEffective]) 
WITH FULLSCAN;
UPDATE STATISTICS [dbo].[DomainNameBlackList] ([PK_DomainNameBlackList]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserBiography] ([PK_UserBiography]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationChannel] ([PK_NotificationChannel]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationChannel] ([_WA_Sys_00000002_5669C4BE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SupplierInvoice] ([PK_SupplierInvoice]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[JobTypeRole] ([PK__JobTypeR__00B970436A8A8707]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[JobTypeRole] ([IX_JobTypeRole_RoleID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewTicket] ([PK_ReviewNextAction]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewTicket] ([IX_ReviewTicket_EntityID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewTicket] ([IX_ReviewTicket_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FaceGameImage] ([PK_FaceGameImage]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderType] ([PK_WorkOrderType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectPermission] ([PK_ProjectPermission]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PaymentTemplateMilestone] ([PK_PaymentTemplateMilstones]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailNotLogged] ([PK_CrmEmailNotLogged]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailNotLogged] ([IX_CrmEmailNotLogged]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketSowEstimate] ([PK_TicketSowEstimate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketSowEstimate] ([UQ_TIcketSowEstimate_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CompanyExtraType] ([PK_CompanyExtraType]) WITH FULLSCAN;
UPDATE STATISTICS [tv].[Channel] ([PK_Channel]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BillingItemDocument] ([PK_BillingItemDocument]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioArtifactType] ([PK_AccountPortfolioArtifactType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserBios] ([PK_UserBios]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationEmailQueue] ([PK_NotificationEmailQueue]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationEmailQueue] ([IX_NotificationEmailQueue_UserID_Sent]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SupplierInvoiceDecisionNextStatus] ([PK_SupplierInvoiceDecisionNextStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SupplierInvoiceDecisionNextStatus] ([_WA_Sys_00000002_587208C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[JsErrorLog] ([PK_JsErrorLog]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewType] ([PK_ReviewType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FactOfTheDay] ([PK_FactOfTheDay]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersion] ([PK_WorkOrderVersion]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersion] ([IX_WorkOrderVersion_WorkOrderHistoryID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersion] ([IX_WorkOrderVersion_BillingMasterWorkOrderID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectPhase] ([PK_ProjectPhase]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectPhase] ([IX_ProjectPhase_Deleted_TicketBoard_TicketBoardList]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectPhase] ([IX_ProjectPhase_ProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EmployeeBiography] ([PK_EmployeeBiography]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EmployeeBiography] ([IX_EmployeeBiography]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PeerRecognition] ([PK_PeerRecognition]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailNotLoggedAddress] ([PK_CrmEmailAdressNotLogged]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketStatus] ([PK_TicketStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketStatus] ([IX_TicketStatus_IsClosed_TicketStatusID_Inc_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketStatus] ([_WA_Sys_00000002_593122D0]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketStatus] ([_WA_Sys_00000003_593122D0]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketStatus] ([_WA_Sys_00000008_593122D0]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CompanySubsidiary] ([PK_CompanySubsidiary]) WITH FULLSCAN;
UPDATE STATISTICS [tv].[Client] ([PK_Client]) WITH FULLSCAN;
UPDATE STATISTICS [tv].[Client] ([UQ_Number]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BillingItemPayment] ([IX_BillingItemPayment_BillingItemID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BillingItemPayment] ([IX_BillingItemPayment_CNBillingItemID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioBillingSetting] ([PK_AccountPortfolioBillingSetting]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserBusinessUnitHistory] ([PK_UserBusinessUnitHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserBusinessUnitHistory] ([IX_UserBusinessUnitHistory_BusinessUnitID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserBusinessUnitHistory] ([IX_UserBusinessUnitHistory_EffectiveExpiry]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserBusinessUnitHistory] ([IX_UserBusinessUnitHistory_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserBusinessUnitHistory] ([_WA_Sys_00000003_59F03CDF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationFilter] ([PK_NotificationFilter]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationFilter] ([_WA_Sys_00000004_5A3A55A2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationFilter] ([_WA_Sys_0000000F_5A3A55A2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationFilter] ([_WA_Sys_00000009_5A3A55A2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationFilter] ([_WA_Sys_00000007_5A3A55A2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationFilter] ([_WA_Sys_00000008_5A3A55A2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SupplierInvoiceDecisionStatus] ([PK_SupplierInvoiceDecisionStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[KeyScanLocation] ([PK_KeyScanLocation]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[KeyScanLocation] ([UQ_KeyScanLocation_Location]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BillingTerm] ([PK_BillingTerm]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewTypeLaborRole] ([PK_ReviewSectionLaborRole]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewTypeLaborRole] ([UQ_ReviewSection_LaborRole]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewTypeLaborRole] ([_WA_Sys_00000003_5A8F5B5D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Feedback] ([PK_Feedback]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Feedback] ([IX_Feedback]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectReconciliationExpense] ([PK_ProjectReconciliationExpense]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EmployeeImage] ([PK_EmployeeImage]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EmployeeImage] ([IX_EmployeeImage]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PeerRecognitionQuestion] ([PK_PeerRecognitionQuestion]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailRating] ([PK_CrmEmailRating]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketStatusTransition] ([_WA_Sys_00000001_5B196B42]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketStatusTransition] ([_WA_Sys_00000002_5B196B42]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CompanySubsidiaryAddress] ([PK_CompanySubsidiaryAddress]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersionEstimate] ([PK_WorkOrderVersionEstimate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersionEstimate] ([UQ_WorkOrderVersionEstimate_WOVIDPhaseID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioBusinessUnitHistory] ([PK_AccountPortfolioBusinessUnitHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioBusinessUnitHistory] ([IX_AccountPortfolioBusinessUnitHistory_BUID]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioBusinessUnitHistory] 
([IX_AccountPortfolioBusinessUnitHistory_EffectiveExpiry]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioBusinessUnitHistory] ([_WA_Sys_00000003_5BAD9CC8]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserCompany] ([PK_UserCompany]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserCompany] ([UC_UserCompany]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserCompany] ([_WA_Sys_00000003_5BD88551]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserCompany] ([_WA_Sys_00000008_5BD88551]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketSystem] ([PK_TicketSystem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationFilterNotificationType] ([PK_NotificationFilterNotificationType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationFilterNotificationType] ([IX_NotificationFilterNotificationType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SupplierInvoiceItem] ([PK_SupplierInvoiceItem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SupplierInvoiceItem] ([IX_SupplierInvoiceItem_ExpenseItem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[KlickTalk] ([PK_KlickTalk]) WITH FULLSCAN;
UPDATE STATISTICS [tv].[Mapping] ([PK_Mapping]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BookingPriority] ([PK_BookingPriority]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewTypeReviewInsightType] ([PK_ReviewTypeReviewInsightType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewTypeReviewInsightType] ([UQ_ReviewTypeReviewInsightType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[File] ([PK_File]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectReconciliationLabor] ([PK_ProjectReconciliationLabor]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EmployeeSource] ([PK__Employee__51E8AFDF06056ED2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PeerRecognitionQuestionResponse] ([PK_PeerRecognitionQuestionResponse]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmEmailView] ([PK_CrmEmailView]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CompanySystem] ([PK_CompanySystem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersionEstimateExpense] ([PK_WorkOrderVersionEstimateExpense]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioContact] ([PK_AccountPortfolioContact]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTag] ([PK_TicketTag]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTag] ([IX_TicketTag_TicketID_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectPhaseType] ([PK__ProjectP__8F2F7163F4C707C4]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectPhaseType] ([_WA_Sys_00000004_5E01903C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectPhaseType] ([_WA_Sys_00000002_5E01903C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationGroup] ([PK_NotificationGroup]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationGroup] ([IX_NotificationGroup_StartDate_EndDate_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationGroup] ([IX_NotificationGroup_UserID_CreatedDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationGroup] ([_WA_Sys_0000000C_5E0AE686]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationGroup] ([_WA_Sys_00000005_5E0AE686]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationGroup] ([_WA_Sys_00000008_5E0AE686]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationGroup] ([_WA_Sys_00000009_5E0AE686]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationGroup] ([_WA_Sys_0000000D_5E0AE686]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationGroup] ([IX_NotificationGroup_DeletedDate_CreatedDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationGroup] ([_WA_Sys_00000003_5E0AE686]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SupplierInvoiceNextStatus] ([PK_SupplierInvoiceNextStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SupplierInvoiceNextStatus] ([_WA_Sys_00000002_5E2AE217]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[KlickTalkAttachment] ([PK_KlickTalkAttachment]) WITH FULLSCAN;
UPDATE STATISTICS [tv].[MappingPermission] ([PK_MappingPermission]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BookingsSnapshot] ([PK_BookingsSnapshot]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewTypeReviewQuestionType] ([PK_ReviewTypeReviewQuestionType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewTypeReviewQuestionType] ([UQ_ReviewTypeReviewQuestionType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewTypeReviewQuestionType] ([_WA_Sys_00000003_5E5FEC41]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FileStorageCheckedHistory] ([PK_FileStorageCheckedHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectReconciliationReason] ([PK_ProjectReconciliationReason]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EmployeeType] ([PK_EmployeeType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EmployeeType] ([_WA_Sys_00000002_5EAA0504]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserConferenceLine] ([PK_UserConferenceLine]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PerformanceAppraisalSurvey] ([PK__Performa__FBF840FEEC12D01D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmFollowUp] ([PK_CrmFollowUps]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CompanyType] ([PK_CompanyType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersionEstimateLabor] ([PK_WorkOrderVersionEstimateLabor]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioExtra] ([PK_AccountPortfolioExtra]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioExtra] 
([IX_AccountPortfolioExtra_AccountPortfolioID_AccountPortfolioExtraTypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioExtra] ([_WA_Sys_00000003_5F7E2DAC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplate] ([PK__TicketTe__92E7183BADB94055]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplate] ([_WA_Sys_00000018_5FDE205F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplate] ([_WA_Sys_00000019_5FDE205F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplate] ([_WA_Sys_00000003_5FDE205F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplate] ([_WA_Sys_0000000B_5FDE205F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplate] ([_WA_Sys_0000001B_5FDE205F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplate] ([_WA_Sys_0000000C_5FDE205F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplate] ([_WA_Sys_0000000A_5FDE205F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplate] ([_WA_Sys_0000000F_5FDE205F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplate] ([_WA_Sys_0000000E_5FDE205F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplate] ([_WA_Sys_00000014_5FDE205F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationGroupEventTypeMember] ([PK_NotificationGroupEventTypeMember]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationGroupEventTypeMember] ([IX_NotificationGroupEventTypeMember_EventTypeID_includes]) 
WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SupplierInvoiceStatus] ([PK_SupplierInvoiceStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[KlickTalkLink] ([PK_KlickTalkLink]) WITH FULLSCAN;
UPDATE STATISTICS [tv].[MappingSchedule] ([PK_MappingSchedule]) WITH FULLSCAN;
UPDATE STATISTICS [tv].[MappingSchedule] ([UQ_MappingSchedule_MappingID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BudgetTransfer] ([PK_BudgetTransfer]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewTypeReviewSection] ([PK_ReviewTypeReviewSection]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewTypeReviewSection] ([UQ_ReviewType_ReviewSection]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewTypeReviewSection] ([_WA_Sys_00000003_604834B3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FileStorageEntity] ([PK_GoogleDriveEntity]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FileStorageEntity] ([FileStorageEntityType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FileStorageEntity] ([IX_FileStorageEntity_BusinessUnitID_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FileStorageEntity] ([IX_FileStorageEntity_EntityType_BusinessUnitID_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FileStorageEntity] ([_WA_Sys_00000009_605D434C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FileStorageEntity] ([IX_FileStorageEntity_ExternalFileID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FileStorageEntity] ([_WA_Sys_00000008_605D434C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FileStorageEntity] ([_WA_Sys_00000004_605D434C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectSetting] ([PK__ProjectSetting__3143F85E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityAccess] ([PK_EntityAccess]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityAccess] ([IX_EntityAccess_AccessToEntityID_AccessToEntityType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityAccess] ([IX_EntityAccess_BelongsToEntityID_BelongsToEntityType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityAccess] ([_WA_Sys_0000000B_60924D76]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityAccess] ([_WA_Sys_00000002_60924D76]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityAccess] ([_WA_Sys_00000004_60924D76]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityAccess] ([_WA_Sys_0000000E_60924D76]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityAccess] ([_WA_Sys_00000006_60924D76]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityAccess] ([_WA_Sys_00000015_60924D76]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityAccess] ([_WA_Sys_00000016_60924D76]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserContactMethod] ([PK_UserContactMethod]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Insight] ([PK_InsightID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Insight] ([UQ_Insight_Type_TaxonomyID_BrandID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PerformanceAppraisalSurveyAnswer] ([PK__Performa__1DFA4E2C3E1878DE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmInterest] ([PK_CrmInterest]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CompanyUser] ([PK_CompanyUser]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersionExpense] ([PK_WorkOrderVersionExpense]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioExtraType] ([PK_AccountPortfolioExtraType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioExtraType] ([IX_AccountPortfolioExtraType_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioExtraType] ([_WA_Sys_00000007_6166761E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioExtraType] ([_WA_Sys_0000000A_6166761E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateCategory] ([PK_TicketTemplateCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateCategory] ([_WA_Sys_00000002_61C668D1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistory] ([PK_NotificationHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistory] ([UC_NotificationHistory_UID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistory] ([IX_NotificationHistory_Created]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistory] ([IX_NotificationHistory_EntityID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistory] ([IX_NotificationHistory_EntityType_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistory] ([IX_NotificationHistory_IsProcessed_EntityType_Created_inc]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistory] ([IX_NotificationHistory_UIDEntityType_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistory] ([IX_NotificationHistory_NotificationTypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistory] ([_WA_Sys_00000011_61DB776A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistory] ([_WA_Sys_00000007_61DB776A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistory] ([_WA_Sys_00000012_61DB776A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SupplierTag] ([PK_SupplierTag]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SupplierTag] ([IX_SupplierTag_Tag]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[KlickTalkTaxonomy] ([PK_KlickTalkTaxonomy2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[KlickTalkTaxonomy] ([KlickTalkTaxonomy_KlickTalkID_TaxonomyID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BudgetTransferProject] ([PK_BudgetTransferProject_1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ReviewWorkOrder] ([PK_ReviewWorkOrder]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FlashReport] ([PK_FlashReport]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FlashReport] ([IX_FlashReport_Created]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FlashReport] ([IX_FlashReport_CreatedBy_Created]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FlashReport] ([IX_FlashReport_CreatedByUID_Created]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FlashReport] ([IX_FlashReport_CreatedByUID_Status]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FlashReport] ([IX_FlashReport_FlashReportID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FlashReport] ([_WA_Sys_0000000A_62458BBE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FlashReport] ([_WA_Sys_00000009_62458BBE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FlashReport] ([_WA_Sys_0000000D_62458BBE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FlashReport] ([_WA_Sys_0000000E_62458BBE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FlashReport] ([_WA_Sys_00000007_62458BBE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStageGate] ([PK_ProjectStageGate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStageGate] ([_WA_Sys_00000002_6265874F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStageGate] ([_WA_Sys_00000005_6265874F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStageGate] ([_WA_Sys_0000000A_6265874F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStageGate] ([_WA_Sys_00000003_6265874F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStageGate] ([_WA_Sys_0000000B_6265874F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityAsset] ([PK__EntityAs__E537CD7A25B1270E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserEmployeeTypeHistory] ([PK_UserEmployeeTypeHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserEmployeeTypeHistory] ([_WA_Sys_00000004_628582E0]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserEmployeeTypeHistory] ([_WA_Sys_00000003_628582E0]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserEmployeeTypeHistory] ([_WA_Sys_00000002_628582E0]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PerformanceAppraisalSurveyDimension] ([PK__Performa__B9681C10CDE117CB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmMood] ([PK_CrmMood]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Contact] ([PK_Contact]) WITH FULLSCAN;
UPDATE STATISTICS [tv].[Show] ([PK_Show]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersionLabor] ([PK_WorkOrderVersionLabor]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioFile] ([PK_AccountPortfolioFile]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateChecklistItem] ([PK__TicketTe__8B6E3492A5EA53C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateChecklistItem] ([IX_TicketTemplateChecklistItem_InputTokenID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateChecklistItem] ([_WA_Sys_00000009_63AEB143]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateChecklistItem] ([_WA_Sys_00000002_63AEB143]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateChecklistItem] ([_WA_Sys_0000000A_63AEB143]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateChecklistItem] ([_WA_Sys_00000005_63AEB143]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SupplierTaxType] ([PK_SupplierTaxType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LaborCategory] ([PK_LaborCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessReportNote] ([PK_BusinessReview]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RewardCategory] ([PK_RewardCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FlashReportItem] ([PK_FlashReportItemID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FlashReportItem] ([IX_FlashReportItem_FlashReportUID_RequestedUrl]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FlashReportItem] ([_WA_Sys_00000003_642DD430]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FlashReportItem] ([_WA_Sys_00000007_642DD430]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FlashReportItem] ([_WA_Sys_00000005_642DD430]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStatus] ([PK_ProjectStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityComment] ([PK_EntityComment]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityComment] ([IX_EntityComment_EntityUID_EntityType_Type]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityComment] ([_WA_Sys_00000003_6462DE5A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityComment] ([_WA_Sys_00000004_6462DE5A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityComment] ([_WA_Sys_0000000B_6462DE5A]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserEntityView] ([IX_UserEntityView_Unique]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserEntityView] ([PK_UserEntityView]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserEntityView] ([IX_UserEntityView_EntityTypeEntityID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserEntityView] ([IX_UserEntityView_EntityTypeViewerUserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserEntityView] ([_WA_Sys_00000009_646DCB52]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserEntityView] ([_WA_Sys_00000004_646DCB52]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserEntityView] ([_WA_Sys_00000006_646DCB52]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserEntityView] ([_WA_Sys_00000005_646DCB52]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PerformanceAppraisalSurveyOption] ([PK__Performa__F6303FB7F8019C25]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmMoodComment] ([PK_CrmMoodComment]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryChannel] ([PK_NotificationHistoryProcessed]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryChannel] ([IX_NotificationHistoryChannel_NotificationHistoryID_inc]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryChannel] ([_WA_Sys_00000003_64B7E415]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContactMeeting] ([PK_ContactMeeting]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContactMeeting] ([IX_ContactMeeting_created]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContactMeeting] ([IX_ContactMeeting_EventID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContactMeeting] ([IX_ContactMeeting_TotalAttendees_StartDate_includes]) WITH FULLSCAN;
UPDATE STATISTICS [tv].[ShowType] ([PK_ShowType]) WITH FULLSCAN;
UPDATE STATISTICS [tv].[ShowType] ([_WA_Sys_00000004_64F7DB37]) WITH FULLSCAN;
UPDATE STATISTICS [tv].[ShowType] ([_WA_Sys_00000006_64F7DB37]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersionOverhead] ([PK_WorkOrderVersionOverhead]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioForecast] ([PK_AccountPortfolioForecast]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioForecast] ([UQ_AccountPortfolioForecast]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplatePermission] ([PK__TicketTe__2DAC3AA56FFF8593]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SupplierTaxTypeITC] ([PK_SupplierTaxTypeITC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LaborRateCard] ([UQ_LaborRateCard_ClientCompanyIDEffective]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LaborRateCard] ([PK_LaborRateCard]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnit] ([PK_BusinessUnit]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnit] ([IX_BusinessUnit_CompanyBusinessUnitID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnit] ([IX_BusinessUnit_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnit] ([IX_BusinessUnit_OrgLevel]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnit] ([IX_BusinessUnit_Path]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnit] ([UQ_BusinessUnit_ParentIDName]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnit] ([_WA_Sys_0000000F_65F62111]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RewardGiftCode] ([PK_RewardGiftCode]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RewardGiftCode] ([UN_RewardGiftCode_Code]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RewardGiftCode] ([IX_RewardGiftcode_RewardTransactionID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FoldersToMove] ([PK_FoldersToMove]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStatus2] ([PK_ProjectStatus2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStatus2] ([_WA_Sys_00000005_66361833]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStatus2] ([_WA_Sys_00000002_66361833]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStatus2] ([_WA_Sys_00000008_66361833]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStatus2] ([_WA_Sys_00000004_66361833]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityDependency] ([PK_EntityDependency]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityDependency] ([UQ_EntityDependency_BaseEntity_DependentEntity]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityDependency] ([IX_EntityDependency_DependentEntity]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityDependency] ([_WA_Sys_00000003_664B26CC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityDependency] ([_WA_Sys_00000006_664B26CC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityDependency] ([_WA_Sys_00000004_664B26CC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityDependency] ([_WA_Sys_00000008_664B26CC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserEventPhoto] ([PK_UserEventPhoto]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserEventPhoto] ([UQ_UserEventPhoto_UserID_EventPhotoID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PerformanceAppraisalSurveyQuestion] ([PK__Performa__A0A6F6263048F149]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmOpportunity] ([PK_CrmOpportunity]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmOpportunity] ([IX_CrmOpportunity_CompanyCreated]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryChannelDigest] ([PK_NotificationHistoryChannelDigest]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContactMeetingAttendeeStatus] ([PK_ContactMeetingAttendeeStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersionPayment] ([PK_WorkOrderVersionPayment]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateRepeat] ([PK_TicketTemplateRepeat]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Survey] ([PK_Survey]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Survey] ([IX_Survey_Answered]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Survey] ([IX_Survey_Created]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Survey] ([IX_Survey_ProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitBrand] ([PK_BusinessUnitBrand]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitBrand] ([_WA_Sys_00000003_67DE6983]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[FreeformRevenueInvoice] ([PK_FreeformRevenueInvoice_1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioForecastMonth] ([PK_AccountPortfolioForecastMonth]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStatusHistory] ([PK_ProjectStatusHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStatusHistory] ([_WA_Sys_00000004_681E60A5]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStatusHistory] ([_WA_Sys_00000002_681E60A5]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectStatusHistory] ([_WA_Sys_00000003_681E60A5]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserExcludeFromC360] ([PK_UserExcludeFromC360]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PerformanceAppraisalSurveyType] ([PK__Performa__D242F0022D2A3337]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmOpportunityDocument] ([PK_CrmOpportunityDocument]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryChannelDigestUser] ([PK_NotificationHistoryChannelDigestUser]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[ContactMeetingContact] ([PK_ContactMeetingContact]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContactMeetingContact] ([IX_ContactMeetingContact_ContactID_ContactMeetingAttendeeStatusID]) 
WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LaborRateCardRole] ([PK_LaborRateCardRole]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RewardItem] ([PK_RewardItem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersionPricing] ([PK_WorkOrderVersionPricing]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersionPricing] ([IX_WorkOrderVersionPricing_WorkOrderVersionIDExpiry]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtra] ([PK_EntityExtra]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtra] ([_WA_Sys_00000002_69279377]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtra] ([_WA_Sys_00000007_69279377]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtra] ([_WA_Sys_00000009_69279377]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtra] ([_WA_Sys_00000003_69279377]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtra] ([_WA_Sys_00000004_69279377]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtra] ([_WA_Sys_00000005_69279377]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityInsightHistory] ([IX_EntityInsightHistory_InsightID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateToken] ([PK__TicketTe__4456BCFA20841C01]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateToken] ([IX_TicketTemplateToken_Sequence]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateToken] ([_WA_Sys_00000010_69678A99]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateToken] ([_WA_Sys_00000008_69678A99]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateToken] ([_WA_Sys_0000000F_69678A99]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateToken] ([_WA_Sys_00000007_69678A99]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateToken] ([_WA_Sys_00000004_69678A99]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateToken] ([_WA_Sys_00000003_69678A99]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SurveyAnswer] ([PK_SurveyAnswer]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitBudget] ([PK_BusinessUnitBudget]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitBudget] ([IX_BusinessUnitBudget_BusinessUnitBudgetGroupID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitBudget] ([IX_BusinessUnitBudget_ManagerUserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitBudget] ([UQ_BusinessUnitBudget_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GeneralLedgerAccount] ([PK_GeneralLedgerAccount]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioLead] ([IX_AccountPortfolioLead_UniqueID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioLead] ([PK_AccountPortfolioLead]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioLead] ([IX_AccountPortfolioLead_AccountPortfolioID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioLead] ([IX_AccountPortfolioLead_LeadTypeIDLeadUserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioLead] ([IX_AccountPortfolioLead_LeadUserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioLead] ([_WA_Sys_00000008_69FBBC1F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioLead] ([_WA_Sys_00000005_69FBBC1F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioLead] ([_WA_Sys_00000004_69FBBC1F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectSubsidy] ([PK_ProjectSubsidy]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserExtra] ([PM_UserExtra]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserExtra] ([UQ_UserExtra]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserExtra] ([_WA_Sys_00000003_6A26A4A8]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserExtra] ([_WA_Sys_00000004_6A26A4A8]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserExtra] ([IX_UserExtra_UserExtraTypeID_UserID_Include]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserExtra] ([IX_UserExtra_UserExtraTypeID_Include]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PerformanceAppraisalUserSurveyType] ([PK__Performa__64ADDCD28666C6EE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmOpportunityDocumentType] ([PK_CrmOpportunityDocumentType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryChannelUser] ([PK_NotificationHistoryUser]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryChannelUser] ([IX_NotificationHistoryChannelUser_NotificationHistoryID]) 
WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryChannelUser] ([IX_NotificationHistoryChannelUser_UserID_Created_inc]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryChannelUser] ([_WA_Sys_00000004_6A70BD6B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryChannelUser] ([_WA_Sys_00000007_6A70BD6B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryChannelUser] ([_WA_Sys_00000006_6A70BD6B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContactMeetingNonClient] ([PK_ContactMeetingNonClient]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LaborRole] ([PK_LaborRole]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LaborRole] ([IX_LaborRole_CategoryMask]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LaborRole] ([IX_LaborRole_IsHourly_LaborRoleID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LaborRole] ([IX_LaborRole_LaborCategoryID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LaborRole] ([IX_LaborRole_LaborRoleID_IsHourly]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LaborRole] ([_WA_Sys_00000002_6AA5C795]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RewardItemAttribute] ([PK_RewardItemAttribute]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersionPricingItem] ([PK_WorkOrderVersionPricingItem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtraType] ([PK_EntityExtraType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtraType] ([UQ_EntityExtraType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtraType] ([_WA_Sys_00000006_6B0FDBE9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtraType] ([_WA_Sys_0000000A_6B0FDBE9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtraType] ([_WA_Sys_00000008_6B0FDBE9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtraType] ([_WA_Sys_00000009_6B0FDBE9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtraType] ([_WA_Sys_0000000F_6B0FDBE9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtraType] ([_WA_Sys_00000002_6B0FDBE9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateTokenParentChildMapping] ([PK_TicketTemplateTokenParentChildMapping]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateTokenParentChildMapping] ([IX_TicketTemplateTokenParentChildMapping_ChildID]) 
WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateTokenParentChildMapping] ([IX_TicketTemplateTokenParentChildMapping_ParentID]) 
WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateTokenParentChildMapping] ([_WA_Sys_00000005_6B4FD30B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SurveyLogo] ([PK_SurveyLogo]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitBudgetGroup] ([PK_BusinessUnitBudgetGroup]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitBudgetGroup] ([UQ_BusinessUnitBudgetGroup_BusinessUnitIDName]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GeneralLedgerAccountType] ([PK_GeneralLedgerAccountType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioLeadType] ([PK_AccountPortfolioLeadType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioLeadType] ([UQ_AccountPortfolioLeadType_Abbreviation]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioLeadType] ([_WA_Sys_00000003_6BE40491]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectSystem] ([PK_ProjectSystem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Permission] ([PK_Permission]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Permission] ([_WA_Sys_00000002_6C23FBB3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmOpportunityEmail] ([PK__CrmOppor__F566D051409DFF89]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryErrorLog] ([PK_NotificationHistoryErrorLog]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryErrorLog] ([_WA_Sys_00000003_6C5905DD]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryErrorLog] ([_WA_Sys_00000004_6C5905DD]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryErrorLog] ([IX_NotificationHistoryErrorLog_NotificationHistoryID]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[ContactMeetingResource] ([PK_ContactMeetingResource]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LaborRoleCategory] ([PK_LaborRoleCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LaborRoleCategory] ([UQ_LaborRoleCategory_Mask]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RewardPointType] ([PK_RewardPointType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersionSchedule] ([PK_WorkOrderVersionSchedule]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersionSchedule] ([IX_WorkOrderVersionSchedule_RecipientProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserExtraType] ([PK_UserExtraType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserExtraType] ([_WA_Sys_00000002_6D031153]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserExtraType] ([_WA_Sys_00000007_6D031153]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserExtraType] ([_WA_Sys_0000000A_6D031153]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserExtraType] ([IX_UserExtraType_Deleted_UserExtraTypeID_Include]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateTokenPermission] ([PK_TicketTemplateTokenPermission]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateTokenPermission] ([IX_TicketTemplateTokenPermission]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateTokenPermission] 
([IX_TicketTemplateTokenPermission_TicketTemplatePermissionType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateTokenPermission] ([_WA_Sys_00000008_6D381B7D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateTokenPermission] ([_WA_Sys_00000004_6D381B7D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateTokenPermission] ([_WA_Sys_00000003_6D381B7D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateTokenPermission] ([_WA_Sys_00000006_6D381B7D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateTokenPermission] ([_WA_Sys_00000005_6D381B7D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketTemplateTokenPermission] ([_WA_Sys_00000007_6D381B7D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SurveyQuestion] ([PK_SurveyQuestion]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitBudgetHistory] ([PK_BusinessUnitBudgetHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GeneSequence] ([PK_GeneSequence]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioMember] ([IX_AccountPortfolioMember_Unique]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioMember] ([PK_AccountPortfolioMember]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioMember] ([IX_AccountPortfolioMember_APIDEffective]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioMember] ([IX_AccountPortfolioMember_MemberUserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioMember] ([_WA_Sys_00000004_6DCC4D03]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioMember] ([_WA_Sys_00000003_6DCC4D03]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioMember] ([_WA_Sys_00000007_6DCC4D03]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectTicketTab] ([PK_ProjectTicketTab]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectTicketTab] ([IX_ProjectTicketTab_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectTicketTab] ([UQ_ProjectTicketTab_ProjectIDName]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityFlag] ([PK__EntityFl__32B92754DCC24DA7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtraTypeScope] ([PK_EntityExtraTypeScope]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtraTypeScope] ([_WA_Sys_00000006_6DF99791]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtraTypeScope] ([_WA_Sys_00000002_6DF99791]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtraTypeScope] ([_WA_Sys_00000003_6DF99791]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtraTypeScope] ([_WA_Sys_00000004_6DF99791]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityExtraTypeScope] ([UQ_EntityExtraTypeScope]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PermissionSystem] ([PK_PermissionSystem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmOpportunityForecastAwardDate] ([PK_CrmOpportunityForecastAwardDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmOpportunityForecastAwardDate] ([UQ_CrmOpportunityForecastAwardDate_OpportunityIDCreated]) 
WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryOnlineAcknowledge] ([PK_NotificationHistoryOnlineAcknowledge]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryOnlineAcknowledge] 
([IX_NotificationHistoryOnlineAcknowledge_IsRead_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryOnlineAcknowledge] 
([IX_NotificationHistoryOnlineAcknowledge_NotificationHistoryChannelUserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryOnlineAcknowledge] 
([IX_NotificationHistoryOnlineAcknowledge_UID_IsRead_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContactMeetingUser] ([PK_ContactMeetingUser]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LauncherCategory] ([PK__Launcher__EFB4FD9A35BF88CB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RewardTransaction] ([PK_RewardTransaction]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersionScheduleExpense] ([PK_WorkOrderVersionScheduleExpense]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserImpersonateHistory] ([PK__UserImpe__9023DC95F4546870]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserImpersonateHistory] ([_WA_Sys_00000002_6EEB59C5]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserImpersonateHistory] ([_WA_Sys_00000003_6EEB59C5]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserImpersonateHistory] ([_WA_Sys_00000006_6EEB59C5]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketType] ([PK_TicketType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketType] ([_WA_Sys_00000002_6F2063EF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SurveyQuestionType] ([PK_SurveyQuestionType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitBudgetStatus] ([PK_BusinessUnitBudgetStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GeneSequencePhase] ([PK_GeneSequencePhase]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GeneSequencePhase] ([_WA_Sys_00000002_6F9F86DC]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AccountPortfolioSwitch] ([PK_AccountPortfolioSwitch]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectType] ([PK_ProjectType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectType] ([UQ_ProjectType_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectType] ([_WA_Sys_00000003_6FBF826D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityPin] ([PK_EntityPin]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityPin] ([IX_EntityPin_EntityID_EntityType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityPin] ([IX_EntityPin_EntityUID_EntityType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityPin] ([IX_UQ_EntityPin]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityPin] ([IX_UQ_EntityPin_PinnableEntityUID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityPin] ([_WA_Sys_00000009_6FD49106]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityPin] ([_WA_Sys_0000000B_6FD49106]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityPin] ([_WA_Sys_00000008_6FD49106]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityPin] ([_WA_Sys_0000000C_6FD49106]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityPin] ([_WA_Sys_00000005_6FD49106]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityPin] ([_WA_Sys_00000002_6FD49106]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PhotoGallery] ([PK_PhotoGallery]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmOpportunityPhase] ([PK_CrmOpportunityPhase]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryTriggeredByUser] ([PK_NotificationHistoryTriggeredByUser]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryTriggeredByUser] 
([IX_NotificationHistoryTriggeredByUser_NotificationHistoryID_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryTriggeredByUser] ([_WA_Sys_00000003_702996C1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContactMethod] ([PK_ContactMethod]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LauncherItem] ([PK__Launcher__F96A307B9E072FA7]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RewardWallet] ([PK_RewardWallet]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkOrderVersionScheduleLabor] ([PK_WorkOrderVersionScheduleLabor]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserInvite] ([PK__UserInvi__0E435BB348853168]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserInvite] ([IX_UserInvite_EntityType_EntityID_Expiry]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserInvite] ([IX_UserInvite_UserIDEntityIDEntityType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityInsightLog] ([PK_EntityInsightLog]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketType2] ([PK__TicketTy__6CD68451158147E3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketType2] ([_WA_Sys_00000002_7108AC61]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SurveySection] ([PK_SurveySection]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitBudgetType] ([PK_BusinessUnitBudgetType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Airport] ([PK_Airport]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectUpdate] ([PK_ProjectUpdate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectUpdate] ([IX_ProjectUpdate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityQueue] ([IX_EntityQueue_EntityID_inc]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityQueue] ([_WA_Sys_00000001_71BCD978]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityQueue] ([_WA_Sys_00000003_71BCD978]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityQueue] ([_WA_Sys_00000004_71BCD978]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityQueue] ([IX_EntityQueue_IsEnabled_GroupID_Inc]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PhotoGalleryImage] ([PK_PhotoGalleryImage]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmOpportunityPhaseHistory] ([PK_CrmOpportunityPhaseHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryValue] ([PK_NotificationHistoryValue]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryValue] ([UC_NotificationHistoryValue]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryValue] ([_WA_Sys_00000003_7211DF33]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationHistoryValue] ([IX_NotificationHistoryValue_NotificationHistoryID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplateChild] ([PK_QueryTemplateChild]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplateChild] ([IX_QueryTemplateChild_QueryTemplateID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[QueryTemplateChild] ([IX_QueryTemplateChild_QueryTemplateID_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContactNonClient] ([PK_ContactNonClient]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LauncherItemSet] ([PK__Launcher__993192DB48AE3525]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[rolap_Bookmark] ([PK_rolap_Bookmark]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GeneSequencePhaseItem] ([PK_GeneSequencePhaseItem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WorkTeam] ([PK_WorkTeam]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityReview] ([PK_EntityReview]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityReview] ([_WA_Sys_00000003_72B0FDB1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityReview] ([_WA_Sys_00000004_72B0FDB1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityReview] ([_WA_Sys_00000002_72B0FDB1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityReview] ([_WA_Sys_0000000B_72B0FDB1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityReview] ([_WA_Sys_00000005_72B0FDB1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityReview] ([_WA_Sys_00000006_72B0FDB1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityReview] ([_WA_Sys_00000007_72B0FDB1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityReview] ([_WA_Sys_00000008_72B0FDB1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserJobTitleHistory] ([UQ_UserJobTitleHistory_UserIDEffective]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserJobTitleHistory] ([PK_UserJobTitleHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserJobTitleHistory] ([_WA_Sys_00000008_72BBEAA9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserJobTitleHistory] ([_WA_Sys_00000004_72BBEAA9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserJobTitleHistory] ([_WA_Sys_0000000A_72BBEAA9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserJobTitleHistory] ([_WA_Sys_00000005_72BBEAA9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserJobTitleHistory] ([_WA_Sys_00000006_72BBEAA9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserJobTitleHistory] ([_WA_Sys_00000003_72BBEAA9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketUserTicketTab] ([PK_TicketUserTicketTab]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SurveyType] ([PK_SurveyType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SurveyType] ([UQ_SurveyType_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitDivision] ([PK_BusinessUnitDivision]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitDivision] ([_WA_Sys_00000002_73501C2F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PhotoType] ([PK_PhotoType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmOpportunityPhaseUser] ([PK_CrmOpportunityPhaseUser]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContactNonClientApplicant] ([PK_ContactNonClientApplicant]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LauncherItemUser] ([PK__Launcher__9128F73915AE87AB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[rolap_Subscription] ([PK_rolap_Subscription]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GenieData] ([PK_GenieData]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GenieData] ([_WA_Sys_00000008_74643BF9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GenieData] ([_WA_Sys_00000009_74643BF9]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WOVBillingAmountTransform] ([PK_WOVBillingAmountTransform]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WOVBillingAmountTransform] ([IX_WOVBillingAmountTransform_Name]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WOVBillingAmountTransform] ([UQ_WOVBillingAmountTransform_Method]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Album] ([PK_Album]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectUpdateHistory] ([PK_ProjectUpdateHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityReviewConcern] ([PK_EntityReviewConcern]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityReviewConcern] ([_WA_Sys_00000006_74994623]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityReviewConcern] ([_WA_Sys_00000002_74994623]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityReviewConcern] ([_WA_Sys_00000003_74994623]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserJobType] ([PK_UserJobType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserJobType] ([IX_UserJobTypeID_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserJobType] ([UQ_UserJobType_UserJobTypeEffective]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserJobType] ([_WA_Sys_00000003_74A4331B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserJobType] ([_WA_Sys_00000005_74A4331B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserJobType] ([_WA_Sys_00000004_74A4331B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketView] ([PK_TicketView]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketView] ([IX_TicketView_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketView] ([IX_TicketView_UserIDViewDate_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketView] ([IX_TicketView_ViewDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplate] ([PK_NotificationFormat]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplate] ([_WA_Sys_00000002_74EE4BDE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SurveyWOIgnore] ([PK_SurveyWOIgnore]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitDivisionLaborRole] ([PK_BusinessUnitDivisionLaborRole]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Playbook] ([PK_Playbook]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Playbook] ([_WA_Sys_00000003_75AD65ED]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Playbook] ([_WA_Sys_0000000A_75AD65ED]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContactNonClientDomain] ([PK_ContactNonClientDomain]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContactNonClientDomain] ([UX_ContactNonClientDomain_Domain]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LeadershipAttribute] ([PK_LeadershipAttribute]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Role] ([PK_Role]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Role] ([IX_Role]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Role] ([_WA_Sys_00000005_763775D2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Role] ([IX_Role_EntityType_EntityID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Role] ([_WA_Sys_00000007_763775D2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Role] ([_WA_Sys_00000009_763775D2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Role] ([_WA_Sys_0000000B_763775D2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Role] ([_WA_Sys_00000004_763775D2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GenomeFSOperation] ([PK_GenomeFSOperation]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GenomeFSOperation] ([IX_GenomeFSOperation_Command]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GenomeFSOperation] ([IX_GenomeFSOperation_CreatedBy]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GenomeFSOperation] ([IX_GenomeFSOperation_EntityID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GenomeFSOperation] ([IX_GenomeFSOperation_EntityType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GenomeFSOperation] ([IX_GenomeFSOperation_Status]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WOVBillingAmountTransformArg] ([PK_WOVBillingAmountTransformArg]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[AlbumItem] ([PK_AlbumItem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectUrl] ([PK_ProjectUrl]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityTag] ([PK_EntityTag]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityTag] ([IX_EntityTag_EntityIDEntityType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityTag] ([IX_EntityTag_EntityType_Created]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityTag] ([IX_EntityTag_IsKudos]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityTag] ([IX_EntityTag_TagID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityTag] ([_WA_Sys_00000007_76818E95]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityTag] ([_WA_Sys_00000008_76818E95]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserKeyscan] ([PK__UserKeys__968E354B73401BB0]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserKeyscan] ([FI_UserKeyscan_LocationNotNull]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserKeyscan] ([IX_UserKeyscan_Date]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserKeyscan] ([IX_UserKeyscan_UserIDDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmProspect] ([PK_CrmProspect]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCache] ([PK_TimeSheetCache]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCache] ([ix_auto_TimeSheetCache_UserIDStopped]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCache] ([IX_TimeSheetCache_2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCache] ([IX_TimeSheetCache_3]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCache] ([IX_TimeSheetCache_Date_ProjectID_Inc_LaborRoleID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCache] ([IX_TimeSheetCache_Date_UserID_ProjectID_Inc_Duration_Method]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCache] ([IX_Timesheetcache_Method]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCache] ([IX_TimesheetCache_ProjectID_Date_Inc_Stopped_UserID_LaborRoleID]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCache] ([IX_TimesheetCache_ProjectIDDateStopped]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCache] ([IX_TimeSheetCache_ProjectIDLaborRoleID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCache] ([IX_TimeSheetCache_ReviewTicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCache] ([IX_TimeSheetCache_TicketID_Inc_Duration]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCache] 
([IX_TimeSheetCache_UserID_Date_ProjectID_Inc_TimeSheetCacheID_Duration_Method]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCache] ([ix_TimeSheetCache_UserID_TicketID_Date_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCache] ([IX_TimesheetCache_UserIDDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCache] ([tscPUDD]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCache] ([IX_TimeSheetCache_ProjectPhaseID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateChannel] ([PK_NotificationTemplateChannel]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateChannel] 
([IX_NotificationTemplateChannel_NotificationTemplateID_NotificationChannelID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateChannel] ([_WA_Sys_00000003_76D69450]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateChannel] ([_WA_Sys_00000005_76D69450]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SurveyWorkOrder] ([PK_SurveyWorkOrder]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitFund] ([PK_BusinessUnitFund]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitFund] ([UQ_BusinessUnitFund_BusinessUnitBudgetIDName]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TagCategoryEntity] ([PK_TagCategoryEntity]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TagCategoryEntity] ([UQ_TagCategoryEntity_TagCategory_EntityType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TagCategoryEntity] ([IX_TagCategoryEntity_TagCategoryID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TagCategoryEntity] ([_WA_Sys_00000003_778C5815]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TagCategoryEntity] ([_WA_Sys_00000005_778C5815]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TagCategoryEntity] ([_WA_Sys_00000006_778C5815]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TagCategoryEntity] ([_WA_Sys_00000004_778C5815]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PlaybookStatus] ([PK_PlaybookStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PlaybookStatus] ([_WA_Sys_00000002_7795AE5F]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContentScopeEntityUser] ([IX_ContentScopeEntityUser]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContentScopeEntityUser] ([IX_ContentScopeEntityUser_UserID_inc]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LeadershipAttributeItem] ([PK_LeadershipAttributeItem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GenomeFSOperationFile] ([PK_GenomeFSOperationFile]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GenomeFSOperationFile] ([IX_GenomeFSOperationFile_FileStorageType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GenomeFSOperationFile] ([IX_GenomeFSOperationFile_GenomeFSOperationID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[WOVBillingAmountTransformScript] ([PK_WOVBillingAmountTransformScript]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Announcement] ([PK_Announcement]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ProjectWorkType] ([PK_ProjectWorkType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityTagHistory] ([IX_EntityTagHistory_EntityIDEntityType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityTagHistory] ([IX_EntityTagHistory_TagID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityTagHistory] ([_WA_Sys_00000007_7869D707]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserLaborRoleHistory] ([PK_UserLaborRoleHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserLaborRoleHistory] ([_WA_Sys_00000002_7874C3FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserLaborRoleHistory] ([_WA_Sys_00000003_7874C3FF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmProspectAction] ([PK_CrmProspectAction]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCacheAutobill] ([PK_TimeSheetCacheAutocompleteFrom]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateChannelHelper] ([_WA_Sys_00000001_78BEDCC2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateChannelHelper] ([_WA_Sys_00000003_78BEDCC2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateChannelHelper] ([_WA_Sys_00000002_78BEDCC2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContentType] ([PK_ContentType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContentType] ([IX_ContentType_ContentType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ContentType] ([UQ_ContentType_FileExtension]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityAction] ([PK_EntityActionID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityAction] ([UQ_EntityAction]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitFundHistory] ([PK_BusinessUnitFundHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleLaborRole] ([PK_RoleLaborRole]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleLaborRole] ([IX_RoleLaborRole_RoleID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleLaborRole] ([_WA_Sys_00000005_7913E27D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleLaborRole] ([_WA_Sys_00000007_7913E27D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleLaborRole] ([_WA_Sys_00000002_7913E27D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleLaborRole] ([_WA_Sys_00000008_7913E27D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleLaborRole] ([_WA_Sys_00000003_7913E27D]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityToken] ([PK_EntityToken]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityToken] ([IX_EntityToken_EntityID_EntityType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PMMAAttendance] ([PK_PMMAAttendance]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PMMAAttendance] ([IX_PMMAAttendance_AccountPortfolioID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PMMAAttendance] ([IX_PMMAAttendance_Date]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PMMAAttendance] ([IX_PMMAAttendance_EntryID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PMMAAttendance] ([IX_PMMAAttendance_EntryType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PMMAAttendance] ([IX_PMMAAttendance_Value]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateChannelLog] ([PK_NotificationTemplateChannelLog]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateChannelLog] 
([IX_NotificationTemplateChannelLog_NotificationTemplateChannelID_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateChannelLog] ([_WA_Sys_00000006_79B300FB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Systems] ([PK_Systems]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LeadershipAttributeJobType] ([PK_LeadershipAttributeJobType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GenomeMedia] ([PK_GenomeMedia]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[Answer] ([PK__Answer__D48250249900E89C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[APForecast] ([PK_APForecast]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[APForecast] ([UQ_APForecast_APIDYearMetricTypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PurchaseOrder] ([PK_PurchaseOrder]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PurchaseOrder] ([IX_PurchaseOrder_Description]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PurchaseOrder] ([IX_PurchaseOrder_ProjectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PurchaseOrder] ([IX_PurchaseOrder_SupplierID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PurchaseOrder] ([IX_PurchaseOrder_SupplierReference]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PurchaseOrder] ([IX_PurchaseOrder_WorkflowTicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserNonPaidLeave] ([PK_UserNonPaidLeave]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserNonPaidLeave] ([UQ_UserNonPaidLeave_UserID_Effective]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmProspectBrand] ([PK_CrmProspectBrand]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCacheHistory] ([PK_TimeSheetCacheHistory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCacheHistory] ([IX_TimeSheetCacheHistoryActionDate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCacheHistory] ([IX_TimeSheetCacheHistoryCacheID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Country] ([PK_Country]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Country] ([_WA_Sys_00000004_7ABC33CD]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitFundItem] ([PK_BusinessUnitFundItem]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RolesByUserCache] ([IX_RolesByUserCache_RoleID_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RolesByUserCache] ([IX_RolesByUserCache_UserID_RoleID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[EntityTool] ([PK__EntityTo__879897622A4D3B9B]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Poll] ([PK_Poll]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateChannelSettings] ([PK_NotificationMasterTemplateChannelSettings]) WITH 
FULLSCAN;
UPDATE STATISTICS [dbo].[SystemSetting] ([PK_SystemSettings_Key]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SystemSetting] ([_WA_Sys_00000004_7BBB44FE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SystemSetting] ([_WA_Sys_00000002_7BBB44FE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[SystemSetting] ([_WA_Sys_00000009_7BBB44FE]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LeadershipCategory] ([PK_LeadershipCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleSuper] ([PK_RoleSuper]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleSuper] ([IX_RoleSuper_SuperRoleIDRoledID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleSuper] ([_WA_Sys_00000004_7BF04F28]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleSuper] ([_WA_Sys_00000006_7BF04F28]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GivingCategory] ([PK_GivingCategory]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AnswerVote] ([PK__AnswerVo__DC3139CFB596F14E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[APForecastMonth] ([PK_APForecastMonth]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PurchaseOrderAttachment] ([PK_PurchaseOrderAttachment]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmProspectEvent] ([PK_CrmProspectEvent]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmProspectEvent] ([IX_CrmProspectEvent]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmProspectEvent] ([IX_CrmProspectEvent_TimeStamp_Desc]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmProspectEvent] ([IX_CrmProspectEvent_To_ProspectID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCacheValidity] ([PK_TimeSheetCacheValidity]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CoworkerRating] ([PK_CoworkerRating]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CoworkerRating] ([UQ_CoworkerRating_CoworkerRatingCode]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitFundStatus] ([PK_BusinessUnitFundStatus]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ErrorMessage] ([PK_ErrorMessage]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserOneOnOne] ([PK_UserOneOnOne]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PollOption] ([PK_PollOption]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateHelper] ([PK_NotificationTemplateHelper]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateHelper] ([_WA_Sys_00000002_7D8391DF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateHelper] ([_WA_Sys_00000003_7D8391DF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateHelper] ([_WA_Sys_00000004_7D8391DF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateHelper] ([_WA_Sys_00000006_7D8391DF]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tag] ([PK_TagID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tag] ([IX_Tag_EntityID_EntityType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tag] ([IX_Tag_IsEnabled_TagCategoryID_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tag] ([UQ_TagName_TagType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tag] ([UQ_UniqueUserTag]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tag] ([_WA_Sys_00000005_7DA38D70]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tag] ([_WA_Sys_00000006_7DA38D70]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tag] ([_WA_Sys_0000000B_7DA38D70]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tag] ([_WA_Sys_00000009_7DA38D70]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tag] ([_WA_Sys_00000003_7DA38D70]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tag] ([_WA_Sys_00000004_7DA38D70]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tag] ([_WA_Sys_0000000F_7DA38D70]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[Tag] ([_WA_Sys_0000000C_7DA38D70]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LeadershipFeedback] ([PK_LeadershipFeedback]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LeadershipFeedback] ([ix_LeadershipFeedback_FeedbackReceiver_Deleted]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleThrottleLimit] ([PM_RoleThrottleLimit]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleThrottleLimit] ([IX_RoleThrottleLimit_RoleID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GivingItem] ([PK_GivingItem]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssessmentAnswer] ([PK__Assessme__59131BC27DD5FE27]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssessmentAnswer] ([IX_AssessmentAnswer_AssessmentResultID_AsessmentQuestionGUID]) WITH 
FULLSCAN;
UPDATE STATISTICS [academy].[AssessmentAnswer] ([IX_AssessmentAnswer_GraderID_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[APForecastUpdate] ([PK_APForecastUpdate]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[APForecastUpdate] ([IX_APForecastUpdate_AccountPortfolioIDMetricTypeID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[APForecastUpdate] ([IX_APForecastUpdate_SourceAPForecastUpdateID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PurchaseOrderDeclaredMonth] ([PK_PurchaseOrderDeclaredMonth]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CrmProspectPriority] ([PK_CrmProspectPriority]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TimeSheetCategory] ([PK_TimeSheetCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[CreditNote] ([PK_CreditNote]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChangeNew] ([PK_TicketChangeNew]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChangeNew] ([IX_TicketChangeNew_AssignedToUserID_HappenedOn_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChangeNew] ([IX_TicketChangeNew_HappenedOn]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChangeNew] ([IX_TicketChangeNew_TicketID_AffectedTable]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChangeNew] ([IX_TicketChangeNew_TicketID_HappenedOn_Inc_AssignedToUserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TicketChangeNew] ([IX_TicketChangeNew_UserID_TicketID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitHierarchy] ([PK_BusinessUnitHierarchy_1]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitHierarchy] ([IX_BusinessUnitHierarchy_Path]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitHierarchy] ([_WA_Sys_00000002_7EC1CEDB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitHierarchy] ([_WA_Sys_00000003_7EC1CEDB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitHierarchy] ([_WA_Sys_00000007_7EC1CEDB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitHierarchy] ([_WA_Sys_0000000B_7EC1CEDB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitHierarchy] ([_WA_Sys_00000006_7EC1CEDB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitHierarchy] ([_WA_Sys_0000000D_7EC1CEDB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[BusinessUnitHierarchy] ([_WA_Sys_00000005_7EC1CEDB]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ErrorMessageInstance] ([PK_ErrorMessageInstance]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[ErrorMessageInstance] ([IX_ErrorMessage]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserPhoto] ([PK_UserPhoto]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserPhoto] ([IX_UserPhoto_IsDefault_includes]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserPhoto] ([IX_UserPhoto_UserID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserPhoto] ([_WA_Sys_00000003_7F21C18E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[UserPhoto] ([_WA_Sys_00000009_7F21C18E]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PollVote] ([PK_PollVote]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateHelperLog] ([PK_NotificationTemplateHelperLog]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateHelperLog] ([_WA_Sys_00000002_7F6BDA51]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[NotificationTemplateHelperLog] ([_WA_Sys_00000006_7F6BDA51]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TagCategory] ([PK_TagCategory]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TagCategory] ([_WA_Sys_00000004_7F8BD5E2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TagCategory] ([_WA_Sys_00000006_7F8BD5E2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TagCategory] ([_WA_Sys_00000002_7F8BD5E2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[TagCategory] ([_WA_Sys_00000007_7F8BD5E2]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[LeadershipFeedbackType] ([PK_LeadershipFeedbackType]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleUser] ([PK_RoleUser]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleUser] ([IX_RoleUser_RoleID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleUser] ([IX_RoleUser_UserIDRoleID]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleUser] ([_WA_Sys_00000009_7FC0E00C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleUser] ([_WA_Sys_0000000B_7FC0E00C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleUser] ([_WA_Sys_00000006_7FC0E00C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleUser] ([_WA_Sys_00000004_7FC0E00C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleUser] ([_WA_Sys_00000003_7FC0E00C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleUser] ([_WA_Sys_00000007_7FC0E00C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[RoleUser] ([_WA_Sys_00000005_7FC0E00C]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[GivingOrder] ([PK_GivingOrder]) WITH FULLSCAN;
UPDATE STATISTICS [academy].[AssessmentAnswerChoice] ([PK_AssessmentAnswerChoice]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[APForecastUpdateMonth] ([PK_APForecastUpdateMonth]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PurchaseOrderForecast] ([PK_PurchaseOrderForecast]) WITH FULLSCAN;
UPDATE STATISTICS [dbo].[PurchaseOrderForecast] ([UQ_PurchaseOrderForecast_POIDEffective]) WITH FULLSCAN;
Done

In old script, it is only executing the modified statistics (9), incase of new script it is displaying modified statistics count as 35 but executing more than that.

Old script which we were using before:

declare @operation nvarchar(10) = '$operation';
declare @mode nvarchar(10) = 'smart';
declare @LogToTable bit = 0;

begin
	set nocount on
	declare @msg nvarchar(max);
	declare @minPageCountForIndex int = 40;
	declare @OperationTime datetime2 = sysdatetime();
	declare @KeepXOperationInLog int =3;
	declare @ScriptHasAnError int = 0; 

	/* make sure parameters selected correctly */
	set @operation = lower(@operation)
	set @mode = lower(@mode)
	
	if @mode not in ('smart','dummy')
		set @mode = 'smart'

	if @operation not in ('index','statistics','all') or @operation is null
	begin
		raiserror('@operation (varchar(10)) [mandatory]',0,0)
		raiserror(' Select operation to perform:',0,0)
		raiserror('     `"index`" to perform index maintenance',0,0)
		raiserror('     `"statistics`" to perform statistics maintenance',0,0)
		raiserror('     `"all`" to perform indexes and statistics maintenance',0,0)
		raiserror(' ',0,0)
		raiserror('@mode(varchar(10)) [optional]',0,0)
		raiserror(' optionaly you can supply second parameter for operation mode: ',0,0)
		raiserror('     `"smart`" (Default) using smart decition about what index or stats should be touched.',0,0)
		raiserror('     `"dummy`" going through all indexes and statistics regardless thier modifications or fragmentation.',0,0)
		raiserror(' ',0,0)
		raiserror('@LogToTable(bit) [optional]',0,0)
		raiserror(' Logging option: @LogToTable(bit)',0,0)
		raiserror('     0 - (Default) do not log operation to table',0,0)
		raiserror('     1 - log operation to table',0,0)
		raiserror('		for logging option only 3 last execution will be kept by default. this can be changed by easily in the procedure body.',0,0)
		raiserror('		Log table will be created automatically if not exists.',0,0)
	end
	else 
	begin
		/*Write operation parameters*/
		raiserror('-----------------------',0,0)
		set @msg = 'set operation = ' + @operation;
		raiserror(@msg,0,0)
		set @msg = 'set mode = ' + @mode;
		raiserror(@msg,0,0)
		set @msg = 'set LogToTable = ' + cast(@LogToTable as varchar(1));
		raiserror(@msg,0,0)
		raiserror('-----------------------',0,0)
	end
	
	/* Prepare Log Table */
		if object_id('AzureSQLMaintenanceLog') is null 
		begin
			create table AzureSQLMaintenanceLog (id bigint primary key identity(1,1), OperationTime datetime2, command varchar(4000),ExtraInfo varchar(4000), StartTime datetime2, EndTime datetime2, StatusMessage varchar(1000));
		end

	if @LogToTable=1 insert into AzureSQLMaintenanceLog values(@OperationTime,null,null,sysdatetime(),sysdatetime(),'Starting operation: Operation=' +@operation + ' Mode=' + @mode + ' Keep log for last ' + cast(@KeepXOperationInLog as varchar(10)) + ' operations' )	

	create table #cmdQueue (txtCMD nvarchar(max),ExtraInfo varchar(max))


	if @operation in('index','all')
	begin
		raiserror('Get index information...(wait)',0,0) with nowait;
		/* Get Index Information */
		select 
			i.[object_id]
			,ObjectSchema = OBJECT_SCHEMA_NAME(i.object_id)
			,ObjectName = object_name(i.object_id) 
			,IndexName = idxs.name
			,i.avg_fragmentation_in_percent
			,i.page_count
			,i.index_id
			,i.partition_number
			,i.index_type_desc
			,i.avg_page_space_used_in_percent
			,i.record_count
			,i.ghost_record_count
			,i.forwarded_record_count
			,null as OnlineOpIsNotSupported
		into #idxBefore
		from sys.dm_db_index_physical_stats(DB_ID(),NULL, NULL, NULL ,'limited') i
		left join sys.indexes idxs on i.object_id = idxs.object_id and i.index_id = idxs.index_id
		where idxs.type in (1/*Clustered index*/,2/*NonClustered index*/) /*Avoid HEAPS*/
		order by i.avg_fragmentation_in_percent desc, page_count desc


		-- mark indexes XML,spatial and columnstore not to run online update 
		update #idxBefore set OnlineOpIsNotSupported=1 where [object_id] in (select [object_id] from #idxBefore where index_id >=1000)
		
		update #idxBefore set OnlineOpIsNotSupported=1  
			where /* Editions that does not support online operation in case this has been used with on-prem server */
				convert(varchar(100),serverproperty('Edition')) like '%Express%' 
				or convert(varchar(100),serverproperty('Edition')) like '%Standard%'
				or convert(varchar(100),serverproperty('Edition')) like '%Web%'
		
		raiserror('---------------------------------------',0,0) with nowait
		raiserror('Index Information:',0,0) with nowait
		raiserror('---------------------------------------',0,0) with nowait

		select @msg = count(*) from #idxBefore 
		set @msg = 'Total Indexes: ' + @msg
		raiserror(@msg,0,0) with nowait

		select @msg = avg(avg_fragmentation_in_percent) from #idxBefore where page_count>@minPageCountForIndex
		set @msg = 'Average Fragmentation: ' + @msg
		raiserror(@msg,0,0) with nowait

		select @msg = sum(iif(avg_fragmentation_in_percent>=5 and page_count>@minPageCountForIndex,1,0)) from #idxBefore 
		set @msg = 'Fragmented Indexes: ' + @msg
		raiserror(@msg,0,0) with nowait

				
		raiserror('---------------------------------------',0,0) with nowait

			
			
			
		/* create queue for update indexes */
		insert into #cmdQueue
		select 
		txtCMD = 
		case when avg_fragmentation_in_percent>5 and avg_fragmentation_in_percent<30 and @mode = 'smart' then
			'ALTER INDEX [' + IndexName + '] ON [' + ObjectSchema + '].[' + ObjectName + '] REORGANIZE;'
			when OnlineOpIsNotSupported=1 then
			'ALTER INDEX [' + IndexName + '] ON [' + ObjectSchema + '].[' + ObjectName + '] REBUILD WITH(ONLINE=OFF,MAXDOP=1);'
			else
			'ALTER INDEX [' + IndexName + '] ON [' + ObjectSchema + '].[' + ObjectName + '] REBUILD WITH(ONLINE=ON,MAXDOP=1);'
		end
		, ExtraInfo = 'Current fragmentation: ' + format(avg_fragmentation_in_percent/100,'p')
		from #idxBefore
		where 
			index_id>0 /*disable heaps*/ 
			and index_id < 1000 /* disable XML indexes */
			--
			and 
				(
					page_count> @minPageCountForIndex and /* not small tables */
					avg_fragmentation_in_percent>=5
				)
			or
				(
					@mode ='dummy'
				)
	end

	if @operation in('statistics','all')
	begin 
		/*Gets Stats for database*/
		raiserror('Get statistics information...',0,0) with nowait;
		select 
			ObjectSchema = OBJECT_SCHEMA_NAME(s.object_id)
			,ObjectName = object_name(s.object_id) 
			,StatsName = s.name
			,sp.last_updated
			,sp.rows
			,sp.rows_sampled
			,sp.modification_counter
		into #statsBefore
		from sys.stats s cross apply sys.dm_db_stats_properties(s.object_id,s.stats_id) sp 
		where OBJECT_SCHEMA_NAME(s.object_id) != 'sys' and (sp.modification_counter>0 or @mode='dummy')
		order by sp.last_updated asc

		
		raiserror('---------------------------------------',0,0) with nowait
		raiserror('Statistics Information:',0,0) with nowait
		raiserror('---------------------------------------',0,0) with nowait

		select @msg = sum(modification_counter) from #statsBefore
		set @msg = 'Total Modifications: ' + @msg
		raiserror(@msg,0,0) with nowait
		
		select @msg = sum(iif(modification_counter>0,1,0)) from #statsBefore
		set @msg = 'Modified Statistics: ' + @msg
		raiserror(@msg,0,0) with nowait
				
		raiserror('---------------------------------------',0,0) with nowait




		/* create queue for update stats */
		insert into #cmdQueue
		select 
		txtCMD = 'UPDATE STATISTICS [' + ObjectSchema + '].[' + ObjectName + '] (['+ StatsName +']) WITH FULLSCAN;'
		, ExtraInfo = '#rows:' + cast([rows] as varchar(100)) + ' #modifications:' + cast(modification_counter as varchar(100)) + ' modification percent: ' + format((1.0 * modification_counter/ rows ),'p')
		from #statsBefore
	end


if @operation in('statistics','index','all')
	begin 
		/* iterate through all stats */
		raiserror('Start executing commands...',0,0) with nowait
		declare @SQLCMD nvarchar(max);
		declare @ExtraInfo nvarchar(max);
		declare @T table(txtCMD nvarchar(max),ExtraInfo nvarchar(max));
		while exists(select * from #cmdQueue)
		begin
			delete top (1) from #cmdQueue output deleted.* into @T;
			select top (1) @SQLCMD = txtCMD, @ExtraInfo=ExtraInfo from @T
			raiserror(@SQLCMD,0,0) with nowait
			if @LogToTable=1 insert into AzureSQLMaintenanceLog values(@OperationTime,@SQLCMD,@ExtraInfo,sysdatetime(),null,'Started')
			begin try
				exec(@SQLCMD)	
				if @LogToTable=1 update AzureSQLMaintenanceLog set EndTime = sysdatetime(), StatusMessage = 'Succeeded' where id=SCOPE_IDENTITY()
			end try
			begin catch
				set @ScriptHasAnError=1;
				set @msg = 'FAILED : ' + CAST(ERROR_NUMBER() AS VARCHAR(50)) + ERROR_MESSAGE();
				raiserror(@msg,0,0) with nowait
				if @LogToTable=1 update AzureSQLMaintenanceLog set EndTime = sysdatetime(), StatusMessage = @msg where id=SCOPE_IDENTITY()
			end catch
			delete from @T
		end
	end
	
	/* Clean old records from log table */
	if @LogToTable=1
	begin
		delete from AzureSQLMaintenanceLog 
		from 
			AzureSQLMaintenanceLog L join 
			(select distinct OperationTime from AzureSQLMaintenanceLog order by OperationTime desc offset @KeepXOperationInLog rows) F
				ON L.OperationTime = F.OperationTime
		insert into AzureSQLMaintenanceLog values(@OperationTime,null,cast(@@rowcount as varchar(100))+ ' rows purged from log table because number of operations to keep is set to: ' + cast( @KeepXOperationInLog as varchar(100)),sysdatetime(),sysdatetime(),'Cleanup Log Table')
	end

	if @ScriptHasAnError=0 	raiserror('Done',0,0)
	if @LogToTable=1 insert into AzureSQLMaintenanceLog values(@OperationTime,null,null,sysdatetime(),sysdatetime(),'End of operation')
	if @ScriptHasAnError=1 	raiserror('Script has errors - please review the log.',16,1)
end
GO

Yochanan_Rachamim

Hi TEAMSZABO  - You can also use SQL Agent to schedule maintenance as well. 

note that this procedure scope is current database, for managed instance you may want to maintain multiple databases.