The performance of the P6 EPPM database depends on an effective configuration of physical design structures, such as indexes or hints, in the database.
Both Oracle and SQL Server have different tools which can be used to diagnose the need for database design performance tuning and is discussed in detail below.