Database Reference
In-Depth Information
---- ----- -------- -----------------------------------------------------------
1 1 0 USE_NL(@"SEL$1" "D"@"SEL$1")
1 1 0 LEADING(@"SEL$1" "EMP"@"SEL$1" "D"@"SEL$1")
1 1 0 OUTLINE_LEAF(@"SEL$1")
1 1 0 ALL_ROWS
1 1 0 IGNORE_OPTIM_EMBEDDED_HINTS
1 1 0 OPTIMIZER_FEATURES_ENABLE('10.2.0.1')
1 1 1 FULL(@"SEL$1" "EMP"@"SEL$1")
1 1 2 INDEX(@"SEL$1" "D"@"SEL$1" ("DEPARTMENTS"."DEPARTMENT_ID"))
User NDEBES is the owner of the outline. Outlines consist of hints, which fully describe
the execution plan for a statement.
