Oracle Corporate developer Vadim Tropashko has some interesting notes on tuning Oracle SQL queries that compare the contents of two tables, showing several SQL solutions and their performance within the Oracle cost-based optimizer. Tropashko has a remarkable approach to solving this problem, a worthy read for anyone who writes SQL in Oracle.
Vadim also shows a great example of using the hidden parameter _convert_set_to_join to improve SQL execution speed for queries that find the semantic difference between two tables, and he shows how to compare the rows and columns of two tables with Oracle SQL syntax.
http://oracle-tips.c.topica.com/maamcioabJ7adbLGJrib/
Vadim Tropashko is the author of the book "SQL Design Patterns: The Expert Guide to SQL Programming".
This is the definitive reference for SQL design patterns, a critical knowledge area for any Oracle developer.
http://oracle-tips.c.topica.com/maamcioabJ7abbLGJrib/
Tricks in Oracle SQL to compare two tables
