Selecting Explain SQL will produce a new window as shown in Figure 4-22
(possible preceded by a message stating that the Explain tables have been
created, if they were missing) where the SQL statement to be explained can be
entered.
Chapter 4. Using the cube model for summary tables optimization 175
Figure 4-22 Explain SQL statement dialog
The advantage of using this approach to explaining SQL statements is that the
access path chosen by the optimizer will be displayed graphically, which makes ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.