Updated on 2026-09-15 GMT+08:00

Using Other EXPLAIN Formats

In addition to the standard EXPLAIN format, you can use explain format=tree and explain format=json to show whether NDP operations are applied.

Disabling NDP

After NDP is disabled, the execution plan is as follows.

Enabling NDP

After NDP is enabled, the execution plan is as follows.