Originally posted on Oracle Scratchpad:

Just like my posting on an index hash, this posting is about a problem as well as being about a hash join. The article has its roots in a question posted on the OTN database forum, where a user has shown us the following execution plan:

1
———————————————————————————————————
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
———————————————————————————————————
| 0 | SELECT STATEMENT | | 14 | 896 | 63 (7)| 00:00:01 |
| 1 | SORT GROUP BY | | 14 | 896 | 63 (7)| 00:00:01 |
| 2 | NESTED LOOPS | | | | | |
| 3 | NESTED LOOPS | | 14 | 896 | 62 (5)| 00:00:01 |
|* 4 | HASH JOIN | | 14 | 280 | 48 (7)| 00:00:01 |
| 5 | VIEW | V_SALES_ALL | 200 | 1800 | 4 (0)| 00:00:01…

View original 1,111 more words

About these ads

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s