_convert_set_to_join tips

Answer:  Oracle Corporation's developer Vadim Tropashko has some interesting notes on using _convert_set_to_join for tuning Oracle SQL queries that compare the contents of two tables, showing several SQL solutions and their performance within the Oracle cost-based optimizer. 

Vadim Tropashko's  is the author of "SQL Design Patterns: The Expert Guide to SQL Programming", the definitive reference for SQL design patterns, a critical knowledge area for any Oracle developer.

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. 

(Note: Hidden parameters are extremely powerful and you should always thoroughly test all use of hidden SQL tuning parameters and only use hidden parms like _coinvert_set_to_join at the direction of Oracle technical support).

Vadim Tropashko's new book "SQL Design Patterns: The Expert Guide to SQL Programming", is the very first book to apply the mathematical foundation of SQL in-terms of design patterns, a must-own book for any professional SQL developer.

For more on advanced Oracle SQL tuning, see Vadim Tropashko's  book "SQL Design Patterns: The Expert Guide to SQL Programming"

Get the Complete Oracle SQL Tuning Information  The landmark book "Advanced Oracle SQL Tuning  The Definitive Reference"  is filled with valuable information on Oracle SQL Tuning. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher.