What is SQL optimization?
SQL optimization involves the identification, analysis, and optimization of SQL statements that are responsible for the highest load as regards I/O at the database level. These statements are also called “processing-intensive SQL statements”. Due to the complexity of the topic, this note can only offer an outline description of an analysis. SAP does, however, offer a number of training courses and services if you wish to find out more information (UMEW60 – Empowering Workshop SAP DB/MaxDB Performance Monitoring and Optimization, WB550 – MaxDB Internals): www.service.sap.com/servicecat -> Support Services -> SAP Solution Management Optimization -> SAP Business Process Performance Optimization, or -> SAP Remote Performance Optimization.