EXPLAIN statement returns the execution plan for a given statement, without executing it. You can use this statement to debug long-running queries and learn how to optimize them.
This code block is a quick reference for the
See some practical examples.
Plan for nested loops join algorithm with IMap on the right side does not show actual access path to the right side data. It is always reported as full scan, even though in reality key lookup or index may be used.