Chapter 6 – Explain

“Fall seven times, stand up eight.”

- Japanese Proverb

Three Ways to Run an EXPLAIN

image

When you run an EXPLAIN, you are seeing the plan passed to the slices by the optimizer on the Leader Node. There are three ways to see an EXPLAIN. First, you can merely type the word EXPLAIN in front of any SQL. Second, you can also hit F6 (Function Key 6). Finally, you can click on the magnifying glass in Nexus. The EXPLAIN shows the plan, but does NOT run the actual query. Once you see the costs of the EXPLAIN, you can decide whether or not to run the query.

EXPLAIN – Steps, Segments and Streams

Step - Each individual step is an individual ...

Get Actian Matrix (Formely ParAccel) - Architecture and SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.