Indexes become fragmented if you frequently create, modify, or delete data within a database. When indexes become fragmented, performance degrades. You can prevent the performance of your database from degrading as a result of fragmentation by monitoring your P6 EPPM indexes and rebuilding them if necessary.
For more information about detecting fragmentation within your database and rebuilding your indexes, refer to the Reorganize and Rebuild Indexes topic in the Microsoft documentation library.