July 2015
Intermediate to advanced
288 pages
7h 26m
English
Oracle explain plans are easily made visible via the Toad Editors Explain Plan output tab and by using the Explain Plan button
. (See the cursor position in Figure 10.1.)
FIGURE 10.1 Toad Explain Plans
Tip
Explain plans and SQL performance tuning are covered in my Safari Books video course: Oracle SQL Performance Tuning for Developers LiveLessons. Set your browser to www.safaribooksonline.com or www.informit.com and search for this course.
Prior to Oracle10, a script was run to create the PLAN_TABLE in your schema. ...