Lesson 1 Using the EXPLAIN PLAN utility
		In the previous module basic SQL tuning and the affects of ANSI standards were discussed. The EXPLAIN PLAN utility is the foremost tool for demonstrating how Oracle accesses tables and indexes. Because this module is one of the most challenging and technical modules, much of the information learned will be used or reinforced in other modules throughout the remainder of the course. By the end of this module, you will be able to: Understand SQL as a declarative language Create a PLAN tabletype Run the EXPLAIN PLAN utilitytype Detect full-table scans with EXPLAIN PLANtype Use EXPLAIN PLAN to diagnose table joinstype Read non-correlated subqueriestype Detect index range scanstype Analyze complex EXPLAIN PLAN outputtype In the next lesson, we will examine SQL access paths.