Automating Azure SQL DB index and statistics maintenance using Azure Automation
Published Mar 13 2019 06:52 PM 94K Views

First published on MSDN on Jan 15, 2018
To provide complete solution to maintain you Azure SQL DB statistics and maintenance we provide our maintenance script here


In this article, we will explain step by step how to automate this maintenance on Azure (You can also use that to automate your own T-SQL tasks)


General steps:


    1. Create Azure automation account

 

    1. Import SQLServer module

 

    1. Add Credentials to access SQL DB

 

    1. Add a runbook to run the maintenance

 

    1. Schedule task



Step by step instructions:


    1. Create new automation account

 

    1. Login to your Azure portal and click "New" (the green plus sign)

 


    1. Type "automation" in the search box, and choose automation.



      Figure 1 – new automation account

 

    1. Click "create"

 


    1. Fill the form, choose a name for your automation account, and choose in which resource group it will be placed.

      make sure you choose "YES" for the Create Azure Run As account.




      Figure 2 – add automation account form.

 


    1. Click "create" and wait for the account to be created. The new automation configuration blade will be opened once the provision completed.

 

    1. Import SQLServer module

 


    1. Click on "Modules" at the left options panel, and then click on "Browse Gallery" and search for "SQLServer"



      Figure 3 – add module

 


    1. Choose "SqlServer" by matteot_msft



      Figure 4 – module name

 

    1. Then click on "import" and the "OK"

 


    1. Wait for the import to complete

 

    1. Add Credentials to access SQL DB

 


    1. This will use secure way to hold login name and password that will be used to access Azure SQL DB

      You can skip this and use it as clear text if you like to use clear text skip to the next step.

 


    1. Under "Shared Resources" click on credentials



      Figure 5 – Add new credential object

 

    1. Then click on "Add Credential"

 

    1. Type "SQLLogin" as the name of the credential.

 

    1. In the username field type the SQL Login that will be used for maintenance and its password.

 


    1. Click "Create"

 

    1. Add a runbook to run the maintenance

 


    1. Click on "runbooks" at the left panel and then click "add a runbook"



      Figure 6 – Add a runbook

 


    1. Choose "create a new runbook" and then give it a name and choose "Powershell" as the type of the runbook and then click on "create"



      Figure 7 – add new PowerShell runbook

 


    1. Copy and paste the following row to the new runbook.

      Make sure you change your database properties.

       


      $AzureSQLServerName = "<ServerName>" 
      $AzureSQLDatabaseName = "<DatabaseName>" 
      
      $AzureSQLServerName = $AzureSQLServerName + ".database.windows.net" 
      $Cred = Get-AutomationPSCredential -Name "SQLLogin" 
      $SQLOutput = $(Invoke-Sqlcmd -ServerInstance $AzureSQLServerName -Username $Cred.UserName -Password $Cred.GetNetworkCredential().Password -Database $AzureSQLDatabaseName -Query "exec [dbo].[AzureSQLMaintenance] @Operation='all' ,@LogToTable=1" -QueryTimeout 65535 -ConnectionTimeout 60 -Verbose) 4>&1 
      
      Write-Output $SQLOutput​




      TIP : to redirect the verbose output to the runbook log we use the technique as described here

 

    1. Click on Publish and confirm.

 

    1. Schedule task

 


    1. Click on Schedules



      Figure 8 – Schedules

 

    1. Click on "Add a schedule" and follow the instructions to choose existing schedule or create a new schedule.

 


    1. Choose a time when the application is in the idlest figure, as running the maintenance might impact on performance while it's executing.



      Figure 9 – Create new Schedule



Monitoring

you can monitor the success of the job by reviewing the Automation overview page



Figure 10 – Job Overview.

then you can click on each category and drill down...



Figure 11 – Job executions

then you can click on a specific execution and get more details about it including the output of the script



Figure 12 – Details of job execution and output information.

I hope you enjoy this post, please share any thoughts on a comment here in this post.

Notes:

    • Automation account has a limit of 500 minutes of execution time per subscription per month on its free tier. More information about automation account limits can be found here



More information:

Getting Started with Azure Automation

Create a standalone Azure Automation account

My first PowerShell runbook

57 Comments
Copper Contributor

Hi Yochanan,

 

I am trying to setup this database maintenance job using Runbooks and I am getting the following errors and I am new to Azure and its not clear why I am getting these two errors.  Our server is set to allow remote connections and the server does exist. Could you share your thoughts? Thanks for the help.

 

Error 1:

AzureSQLServerName : The term 'AzureSQLServerName' is not recognized as the name of a cmdlet, function, script file, or
operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try
again.
At line:1 char:1
+ AzureSQLServerName = "*****.database.window ...
+ ~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ObjectNotFound: (AzureSQLServerName:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException

 

2nd error:

 

Invoke-Sqlcmd : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.) At line:6 char:16 + ... LOutput = $(Invoke-Sqlcmd -ServerInstance $AzureSQLServerName -Userna ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [Invoke-Sqlcmd], SqlException + FullyQualifiedErrorId : SqlExceptionError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand  

 

Thanks,

Kumar.

Copper Contributor

You need add modules under automation account. 

 

Copper Contributor

Is there a way I can exclude a particular table from this maintenance job? There is a large table in our database and collecting stats and rebuilding indexes on them takes forever and the job never completes. 

 

Thanks,

Kumar.

Copper Contributor

@Kumar_Vivekanandam - at this time we do not have that option for the maintenance, however you can edit the maintenance procedure and exclude the table you like to exclude.

 

Copper Contributor

Thank you @Yochanan_Rachamim . I will review the code to check where the table needs to be excluded.

 

Thanks,

Kumar.

Copper Contributor

@Yochanan_Rachamim  does the script take SAMPLE or FULLSCAN as parameters. I couldn't see in the code, but just double checking if this was intentional or just not amended as such yet  ?

Thanks,

 

Chris

@woodsy1978  - I didnt include this as parameter as I would recommend to use FullScan to get better quality for the statistics. 

however, this is T-SQL code so you can modify it for your needs. 

 

HTH, 

Yochanan

Copper Contributor

i followed the steps and getting error error Couldnt find stored procedure  dbo.AzureSQLMaintenance  . How to fix this error>

Hi @sreedxc 

 

please follow the link at the first line in this article ... it will lead you to the procedure page where you can download the code to create the maintenance procedure.

 

here is the link again for your convenience: 

https://blogs.msdn.microsoft.com/azuresqldbsupport/2016/07/03/how-to-maintain-azure-sql-indexes-and-...

Copper Contributor

if we want to run the proc on  multiple database in azure sql how to run it one by one on each database ?

Copper Contributor

 also what DB permission are needed ? will the schema /database suffice or we require sa/admin privilege?

Copper Contributor

Hi Yochanan,

Does the proc update both rowstore and column indexes? when i run the query from microsoft site for column store and rowstore

https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?vie...

after  running your maintenance procedure all the columnstore defrag is cleared. However when i run query for defrag on rowstore index still objects show up. Can you check?

 

SELECT a.object_id, object_name(a.object_id) AS TableName,
    a.index_id, name AS IndedxName, avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats
    (DB_ID (N'AdventureWorks2016_EXT')
        , OBJECT_ID(N'HumanResources.Employee')
        , NULL
        , NULL
        , NULL) AS a
INNER JOIN sys.indexes AS b
    ON a.object_id = b.object_id
    AND a.index_id = b.index_id;
GO

 

Hi @sripu 

for SQL DB the scope is always one database. (as you know - cross database queries are not available on Azure SQL DB) 

therefore you should run that on each database individually. 

 

Azure SQL Elastic Jobs do great job about it and it can be used to execute the maintenance on your databases. 

 

Regards, 

Yochanan (MSFT)

 
Copper Contributor

Hi Yochanan 

Could you look at my query "after  running your maintenance procedure all the columnstore defrag is cleared. However when i run query for defrag on rowstore index still objects show up. Can you check?

 

Thanks

Sreedhar

Hi @sreedxc 

I'm not sure I understand the question - can you share some more information about it? 

 

Yochanan.

Copper Contributor

Hello Im testing the runbook, but i get the next message. I have already enable the firewall rules and created the user in the database

 

Invoke-Sqlcmd : Cannot open database "********.database.windows.net" requested by the login. The login 

failed.

Login failed for user '******'.

At line:6 char:16

+ ... LOutput = $(Invoke-Sqlcmd -ServerInstance $AzureSQLServerName -Userna ...

+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    + CategoryInfo          : InvalidOperation: (:) [Invoke-Sqlcmd], SqlException

    + FullyQualifiedErrorId : SqlExceptionError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

 

Invoke-Sqlcmd : 

At line:6 char:16

+ ... LOutput = $(Invoke-Sqlcmd -ServerInstance $AzureSQLServerName -Userna ...

+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    + CategoryInfo          : ParserError: (:) [Invoke-Sqlcmd], ParserException

    + FullyQualifiedErrorId : ExecutionFailureException,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

 Any ideas

 

Thanks  in advance

Copper Contributor

Can we perform all steps for Azure Managed Database Instance?

I am trying to perform this on Azure Managed database instance. But getting following error message

 

Invoke-Sqlcmd : A network-related or instance-specific error occurred while establishing a connection to SQL Server. 
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is 
configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the 
connected party did not properly respond after a period of time, or established connection failed because connected 
host has failed to respond.)
At line:6 char:16
+ ... LOutput = $(Invoke-Sqlcmd -ServerInstance $AzureSQLServerName -Userna ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [Invoke-Sqlcmd], SqlException
    + FullyQualifiedErrorId : SqlExceptionError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand
 
Invoke-Sqlcmd : 
At line:6 char:16
+ ... LOutput = $(Invoke-Sqlcmd -ServerInstance $AzureSQLServerName -Userna ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : ParserError: (:) [Invoke-Sqlcmd], ParserException
    + FullyQualifiedErrorId : ExecutionFailureException,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

Hi @aarango235 

the error message is clear. login was failed. 

this mainly happen when wrong login name or password was used. 

try to check that.

if you need more help please open support case and we will be more than happy to help you figure out the reason. 

 

Regards,

Yochanan. 

Hi @VaishnavIndurkar 

Yes, you may use this for Managed Instance as well. 

This error is not related specifically for this script but it indicate that connection failed, it seems like network access failed. 

you may access MI using automation account via public endpoint as internal IP is not accessible via Automation account. 

 

Regards, 

Yochanan.

Copper Contributor

Hi @Yochanan_Rachamim 

 

I have setup azure SQL maintenance as per this article. But while running the runbook, I am getting below error. Now, I know this is related to network, but what can be done to fix this. I have already allowed by client ip on Azure firewall. Not sure where am I missing. Would you please be able to help me out here.

 

Invoke-Sqlcmd : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.) At line:6 char:16 + ... LOutput = $(Invoke-Sqlcmd -ServerInstance $AzureSQLServerName -Userna ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [Invoke-Sqlcmd], SqlException + FullyQualifiedErrorId : SqlExceptionError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

Hi @kulpreetm 

 

This error means that the client ( here it is the automation runbook ) is not able to find the SQL Server

for SQL DB the most common reason for that is just a typo with the server name. 

please make sure the server is written in the format of: tcp:<your_server_name>.database.windows.net,1433

if you still face some issue please open a support case on Azure portal and we will be more than happy to help you. 

 

Yochanan.

Copper Contributor

Hi Yochanan,

 

What is the purpose of Azure Run As account in this setup? Is it really needed?

I have set up the Azure Automation Account without Azure Run As account and it works perfectly fine.

 

Regards

Tabrez

Hi @tabrezgm 

In this setup I'm using credentials object (not run-as account as you mentioned) to keep the database credentials safe

otherwise it will be visible in clear text for everyone who is viewing the runbook. 

 

if this is not a concern for you, you can use the database credentials directly in the runbook and it will work perfectly as well. 

 

Yochanan.

Copper Contributor

Hi @Yochanan_Rachamim

 

Your article is very helpful and thanks for providing very detail information.

Is it also possible to loop all databases in the given SQL Server instead of passing specific database name as below?

 

$AzureSQLServerName = "<ServerName>"

$AzureSQLDatabaseName = "<DatabaseName>"

 

This is because our database name is changing every after the release so I'm figuring out how to apply this for our case.

 

Thank You

Hi @Myat_Thet ,

 

yes, you can wrap the execution in a loop that go trough each database.

you need to make sure the procedure created in each database as we have no cross-database query ability for Azure SQL DB. 

 

however, I would suggest you to use Elastic Jobs instead, there you can target the database and the execution will be managed by Elastic jobs agent. 

also, for execution account you have time limit which is not present in Elastic jobs and therefore it make it more feasible for you. 

 

Yochanan.

Copper Contributor

Hi @Yochanan_MSFT 

is it possible to somehow use managed identity? or fetch creds from azure key vault securely? somehow fix solution that will not store credentials and would require to rotate creds in future.

Hi @martinHBA - as today we have elastic job agent it will be better to use it to automate the process. 

you may also use service principal or access token to connect to your database. 

it will change the implementation a bit, but it's possible. 

 

HTH, 

Yochanan.

Copper Contributor

@Yochanan_Rachamim if this solution is used with a managed instance, is there any reason that an SQL Server Agent job could not execute the AzureSqlMaintenance procedure based on a schedule instead of using the Azure automation (assuming of course that the SQL Server Agent has access to the managed instance)?

 

Thank you.

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.

Copper Contributor

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

 

nreddipalle_1-1609428878178.png

nreddipalle_0-1609428784690.png

@Yochanan_Rachamim

@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.

 

 

 

 

Copper Contributor

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

Copper Contributor

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 @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. 

 

 

 

 

 

 

 

Copper Contributor

getting error on line 529 

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

Copper Contributor

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. 

Copper Contributor

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

@sreedxc

It seems that before you execute the script you explicitly begin transaction.

This is not needed, and especially for resumable operation - we cannot run it within the context of transaction.

 

Please avoid opening transaction before running the maintenance

Copper Contributor

when the setting " Allow Azure services and resources to access this server" is set to NO i get firewall errors. Is there a way to whitelist any specific IPs to make this run? alternatively can i use any other option to schedule the proc without runbooks which has some restriction due to firewall

Hi @sreedxc - using runbook means that you are using automation infrastructure, therefore it needs to be allowed by Azure SQL DB firewall. as this is a service you do not have a specific outgoing IP so you can whitelist it. 

some options you may consider: 

* Use hybrid worker, in such case your own machine will execute the maintenance and it use its own IP address - the complexity here is that you need to maintain your own worker. 

* Configure Azure SQL DB firewall to allow Azure automation IP range (not so realistic, as it has many ranges, and you are limited by 128 rules for SQLDB firewall, as well as this needs maintenance and update manually)

* Allow Azure Services to access the database (this means that every Azure resource can communicate with your database) 

 

if the above is not suitable for you, you may review your existing automation \ jobs tools to run the maintenance.

 

HTH, 

Yochanan

 

Copper Contributor

Hi Yochanan,

This works well so thank you for the great blog. However, we find some of the databases are massive and we wanted to see if you had any suggestions to how we could add a time limit to the maintenance.. IE we only have a 100 Min window when its not being used, so we cant run full maintenance all the time, this works as it always takes the highest fragmented indexes first - then periodically we have a longer window where we can upscale the Database and run full maintenance, then down scale back to production cores.

This way we do as much maintenance in a small window as possible and we find if we do this nightly we actually do catch up with the normal fragmentation. anything that spills over gets done in the monthly longer window.

But currently, we have to interrupt the automation manually. we were hoping for some sleep and have the automation stop the query after X time.

regards
Matt



 

Hi @Matt Darnell - Thank you for reaching out, and I'm very happy you find it useful for you.

I've created work item here https://github.com/yochananrachamim/AzureSQL/issues/26 to track this request. 

feel free to add more suggestions there and help with the design so it will be best for you. 

Yochanan. 

Copper Contributor

@Yochanan_Rachamim- This is super helpful. Thanks for sharing.

For some reason, the output of the logs is not respecting the line breaks and making it very hard to read. Any ideas what could be causing this?

My Job:

 

...

# Execute query
$SQLOutput = $(invoke-sqlcmd -ServerInstance "$SQL_Server_Name" -Database "$SQL_DB_Name" -Credential $SQLServerCred -Query "$Query" -Encrypt -Verbose) 4>&1 

Write-Output $SQLOutput

 

 

Output:

smurtagh_0-1647017304226.png

 

Happens in both the 5.1 and 7.1 runtimes.

Copper Contributor

Hi @Yochanan_MSFT,

 

Thanks for this script, I've been able to run manually, but when trying to run it through runbooks I get the following error: 

 

Invoke-Sqlcmd : The target principal name is incorrect. Cannot generate SSPI context. At line:4 char:16 + ... LOutput = $(Invoke-Sqlcmd -ServerInstance $AzureSQLServerName -Databa ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [Invoke-Sqlcmd], SqlException + FullyQualifiedErrorId : SqlExceptionError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

I've removed the credentials and reverted the module version to 5.1. I was getting more errors on version 7.1. 

 

Please let me know if you have any ideas.

Hi @tqrecords 

Using automation account, we are only invoking the execution of the procedure. 

Something is wrong with the credentials or the credential object. 

To test it, you may use the login name and password hard coded in the runbook just to validate it. 

based on the result you might find where the problem is. 

If you need more assistance, please raise a support ticket with us and mention this comment - I will be more than happy to guide you further. 

 

 

 

Copper Contributor

I have been able to import the SQLServer module in my automation account when working in Azure in the US.  However, when I search for that module in the Europe Azure environment I can't find it.  What do I need to do? 

Hi @kwc1059  - Thank you for reaching out. 

I've just tried it myself in West Europe and I was able to find the module. I would suggest that you open a support request for Azure Automation to solve it. I will be happy to be engaged as well if needed. 

Copper Contributor

Yochanan,

 

Thank you for the write-up and the detailed information, it is most helpful. I have setup a new runbook and schedule per the instructions and the runbook ran as I can see the AzureSQLMaintenanceLog table with entries in the database, but I am not seeing any details in the Runbook Output. Also, Runbook status was "Stopped" it looked like it ran for 3 hours or so, do you know where that timeout would have come from?

tjestesjr_0-1673536058827.png

 

Version history
Last update:
‎Sep 08 2019 03:45 AM
Updated by: