G555: Major Topics

Posted on December 31, 2012 at 3:26 am.

• Relational access concepts
• EXPLAIN, PLAN_TABLE, and DSN_STATEMNT_Table
• Access strategies
• Use of indexes
• Filter factors
• Indexable, Stage 1, and Stage 2 predicates
• Nested Table Expressions
• Joins: Inner, Outer, and Full
• Subqueries
• Unions
• Joined access strategies – nested loop, merge scan, hybrid
• Subquery access strategies
• Cursor performance

×

Comments are closed.