(Iggy Fernandez) The execution plans in the last post were interesting—especially the one in which the child table was counter-intuitively used as the lookup table during the antijoin. It just goes to show what a wealth of possibilities is available to the Oracle query optimizer.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help