Solution : https://service.sap.com/sap/support/notes/772497 (SAP Service marketplace login required)
Summary :
SAP Note discusses the effective use of Oracle hints in SAP environments. Oracle typically optimizes SQL queries based on cost or rules, but hints can be specified to enforce a particular access path. These hints are directly inserted into the SQL queries and can significantly influence the execution plan. The note covers different types of hints, such as CACHE, INDEX, and FIRST_ROWS, each serving specific purposes like improving buffer utilization, favoring certain indices, or optimizing join operations. Instructions for proper syntax and placement of hints within SQL statements are provided, alongside insights on potential pitfalls and the impact of hints on database performance.
Key words :
components sv-bo backoffice service delivery priority recommendations / additional info category faq validity, reference-> 5 optimizer hintssql reference-> basic elements, customer component bc-db-ora oracle, oracle sql-> comments header data released, index access versus full table scan, open sql 135048 long runtimes statements, hints' profile parameter 881083 blocking factors, equi_check_asset function module 789011 faq, /3 parameter dbs/ora/use_hints, dbs/ora/use_hints parameter
Related Notes :
| 1853295 | |
| 1138411 | Performance of rescheduling |
| 902675 | MB51: Database hints to improve runtime / 4.70 |
| 902157 | MB5B: Improving the runtime using database hints/4.70 |
| 881083 | Blocking factors on Oracle-based systems |
| 825653 | Oracle: Common misconceptions |
| 817810 | PM-AA: Runtime problems in EQUI_CHECK_ASSET function module |
| 789011 | FAQ: Oracle memory areas |
| 766349 | FAQ: Oracle SQL optimization |
| 750631 | Approximations for cost calculation of the CBO |
| 724545 | Adjusting the CBO statistics manually using DBMS_STATS |
| 712624 | High CPU consumption by Oracle |
| 651060 | FAQ: Oracle Parallel Execution |
| 176754 | Problems with CBO and RBO |
| 135048 | Long runtimes statements w/ ROWNUM <= condition |
| 129385 | Database hints in Open SQL |