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…