Real-world SQL optimization case 2 _ access path optimization
1. problem description
Generate database AWR report: August 22, 10:00 to 18:00, TOP1 SQL: 3g5996z6awjux, run times: 217677 times, execution time of each time: 7.38 seconds, total database resources (elapsed time): 43.22%.
2. problem analysis
SQL statement:
bind variable gets from v$sql_bind_capture
4. Summary Via Access Path Optimization: Execution time before optimization: 614 seconds, after optimization: 83 seconds.
