Tuning SAP MaxDB This section provides background information and hints about SAP MaxDB Tuning. If you are SAP employee, you can access the SAP MaxDB in the BIS information system for further information. In the Support Section -> Guides you'll find our current performance guide.

MaxDB Tuning is moderated by Christiane Hienger.

Database Configuration — This section deals with information about database configuration e.g. Volumes, Parameters. SQL Optimizer — This section gives detailed information about the MaxDB Optimizer. Primary Keys and Indexes — This section explains the primary key concept of MaxDB and also covers secondary keys (indexes). Statistics — The significance of the statistics for the MaxDB Optimizer is described in detail in this section. Internal File Size Information — This section gives detailed information about this new functionality in 7.6. The internal file size information is used by the MaxDB Optimizer as well to find the best strategy.

Performance Analysis Tools — This section describes the general tools and transactions for performance monitoring. MaxDB BW Feature Package — As of version 7.6.01 Build 04 the BI FeaturePack is available, which improves the performance especially in BW systems. Step-by-step Guide - Procedure in a Performance Analysis — This guide deals with the analysis and optimization of performance problems. SAP MaxDB Services — This section gives detailed information about available SAP MaxDB Services. FAQ Performance — This section answers questions about global MaxDB performance issues.