Execution Plan - MYSQL
It is the graphical representation of query executed on database. Each node in it plays significant role in query. Click on node for more information.
1 row(s)
Single Row(Constant)
this_
idxUnique_user_master_email
1 row(s)
Non-Unique Key Lookup
creditcard2_
fk_creditcard_user_master_idx
2 row(s)
Non-Unique Key Lookup
messages1_
fk_message_user_master_idx
Query Statistics
Executed Query
select * from user_master this_ inner join message messages1_ on this_.id=messages1_.user_id inner join creditcard creditcard2_ on this_.id=creditcard2_.user_id where this_.email='vicky.thakor@javaquery.com'
SQLAnalyzer
SQLAnalyzer, an Open source SQL Query analysis library. Now don't just write SQL Query, understand the behind scene actions.
Why SQLAnalyzer created?
Developer thinks having high processing hardware allows them to interact database with unstructured SQL Query. Well writing structured query is really a big deal.
Now Developer can optimize the SQL Query in development phase using
SQLAnalyzer and SQL Queries will give their best on Production environment. SQLAnalyzer can generate
Graphical Analysis report of your SQL Query right from the CODE no extra configuration required on database.
Warning
SQLAnalyzer is analysis tool and should be used at development phase. It'll cost a lot on Production environment so comment/delete SQLAnalyzer code before you deploy your code on Production environment.
Note
- Third party tool's rights reserved by their respective authors.
- Files required to view this HTML report 1.) SQLAnalyzerIconImage.png 2.) jquery-1.8.2.min.js 3.) jquery.jsPlumb-1.3.3-all.js
- Icon Not Found, it represents that this particular operation not handled in SQLAnalyzer. Please report it on vicky.thakor@javaquery.com with operation displayed under icon.