MySQLExecutionPlan

Description

Reverse-engineer MySQL’s EXPLAIN output into a query execution plan and format the plan as it is represented inside MySQL

The execution plan visually would be represented as a depth-first tree. In other words, the root of the tree is the output node .

The output will appear in a pane below the Table Properties in the right bottom pane.

+---------------------+ +-------------------------------------------+
|                     | | <Table name> information                  |
|                     | +-------------------------------------------+
| SQL Editor          | | [[History ] Schema | Column ]          |
|                     | |                                           |
|                     | |  List                                     |
|                     | |  +-------------------------------------+  |
|                     | |  | previously executed SQL statement 1 |  |
|                     | |  | previously executed SQL statement 2 |  |
|                     | |  +-------------------------------------+  |
|---------------------| +-------------------------------------------+
|                     | 
| Results             | +-------------------------------------------+
|                     | | MySQL plan (if connection is to MySQL)    |
|                     | +-------------------------------------------+
|                     | |   SUBQUERY                                |
|                     | |         +- JOIN                           |      
|                     | |         |  +- Index lookup                |
|                     | |         |  |  key                         |
|                     | |         |  |  possible_keys               |
|                     | |         |  |  key_len                     |
|                     | |                                           |
|                     | |                                           |
|                     | |                                           |
+---------------------+ +-------------------------------------------+

Not logged in. Log in, Register

By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo