“Fall seven times, stand up eight.”
- Japanese Proverb
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. You can merely type the word EXPLAIN in front of any SQL. You can also hit F6 (Function Key 6), or 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.
Step - Each individual step is an individual operation in the explain ...