My Oracle Support Banner

How to Gather Statistics on a SQL Server Database (Doc ID 904287.1)

Last updated on JULY 24, 2023

Applies to:

Primavera Contractor - Version 6.1 and later
Primavera P6 Enterprise Project Portfolio Management - Version 7.0 and later
Primavera P6 Professional Project Management - Version 7.0 and later
All Platforms


This document provides instructions for gathering statistics against a P6 EPPM or P6 Professional database hosted on a Microsoft SQL Server platform.

SQL Server uses statistical information to estimate the number of rows in the query result to be returned, which enables the built-in Query Optimizer to create a high-quality query execution plan.  If the statistics are out of date (due to a large change or accumulated small changes to the data) the Optimizer is using old data, which causes inefficient query plans to be run and results in slower database performance.

Gathering statistics can potentially resolve the following symptoms:


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 To determine the last time statistics were gathered per index, per table:
 Gather SQL Server statistics using the recommended method:
 Gather SQL Server statistics using the full-scan method:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.