Update the INOW Database Statistics - Moving INOW Database from SQL Server to another SQL Server Machine - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Moving INOW Database from SQL Server to another SQL Server Machine
Platform
Perceptive Content
Product
Moving INOW Database from SQL Server to another SQL Server Machine
Release
Foundation 24.1
License

To update the statistics for the INOW database tables, complete the following steps.

Note: During this process, the system performs a full scan of tables and indexes, so the time it takes to complete this action varies based on the size of the database.
  1. Copy and paste the following command set in the Query tab. 

USE INOW 
GO 

EXEC sp_MSforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN' 
GO
  1. On the toolbar, click Execute.