Update the INOW Database Statistics - Update the INOW Database Statistics - Moving INOW Database from SQL Server to another SQL Server Machine - Foundation 25.1 - Foundation 25.1 - Ready - Perceptive Content - external - Perceptive-Content/Moving-INOW-Database-from-SQL-Server-to-another-SQL-Server-Machine/Foundation-25.1/Moving-INOW-Database-from-SQL-Server-to-another-SQL-Server-Machine-Best-Practices/Moving-the-INOW-Database-from-SQL-Server-to-Another-SQL-Server-Machine/Prepare-to-Move-the-Database/Update-the-INOW-Database-Statistics - 2025-07-21

Moving INOW Database from SQL Server to another SQL Server Machine Best Practices
Platform
Perceptive Content
Product
Moving INOW Database from SQL Server to another SQL Server Machine
Release
Foundation 25.1
License
ft:lastPublication
2025-07-21T12:16:52.932000
ft:locale
en-US

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.