This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 134212

Summary:	Show execution plan for MySQL
Product:	db	Reporter:	John Baker <jbaker>
Component:	Code	Assignee:	Jiri Rechtacek <jrechtacek>
Status:	RESOLVED DUPLICATE
Severity:	blocker	CC:	nleck
Priority:	P2
Version:	6.x
Hardware:	All
OS:	All
URL:	http://wiki.netbeans.org/MySQLExecutionPlan
Issue Type:	ENHANCEMENT	Exception Reporter:

Description John Baker 2008-04-30 01:33:39 UTC

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

Comment 1 David Vancouvering 2008-05-27 19:40:15 UTC

This doesn't actually make sense unless we can provide a graphical view. For a simple text-based view, the user can just
put the keyword "EXPLAIN" in front of their statement.

Comment 2 nleck 2009-03-06 00:26:33 UTC

With Sybase it's set showplan on; which will produce text the SQLWarnings. 

Just printing this out will be fine.

Comment 3 Jiri Rechtacek 2009-10-16 14:08:02 UTC

Reassigned to new owner.

Comment 4 Jiri Rechtacek 2009-10-23 09:15:17 UTC


*** This issue has been marked as a duplicate of 164885 ***