Tag Archives: Oracle SQL execution plan tuning

SAP program performance tuning – Suboptimal SQL execution plan part 2 of 2

This continues my previous post on Oracle SQL execution plan issue. My previous analyzed a SAP ST12 trace and found program spent most of time on a SQL statement which is using hash join method to retrieve data from two tables. And one step in the hash join is to build hash table using 1…

This content is for 1 day, 1 Month, 365 days and Life-time members only.
Log In Register