2017997 - How to rebuild indexes on MS SQL Server PCM database? - PCM | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2017997 - How to rebuild indexes on MS SQL Server PCM database? - PCM

Symptom

  • All of the tables within the database are strategically indexed to maximize performance. These indexes need to be maintained as part of a regular maintenance schedule.
  • The indexes have an impact on the overall system performance, and it is recommended that they are regularly rebuilt, typically after loading data (using Data Bridge or Data Loader).

Read more...

Environment

  • SAP Profitability and Cost Management (PCM) 10.0
  • Microsoft SQL Server as Database Server

Product

SAP Profitability and Cost Management 10.0

Keywords

EPM, EPO, SAP-PCM, SBOP PCM, EPM-PCM, DBA, DB, rebuild, indexes, SQL, maintenance plan , KBA , EPM-PCM-DAT , Database , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.