Execution Plan - Microsoft SQL Server
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.
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'
Console
StatementSubTreeCost
0.030915
StatementOptmEarlyAbortReason
GoodEnoughPlanFound
StatementText
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'
QueryPlanHash
0xC8157A4553F872A8
LAST_EXECUTION_TIME
2016-07-17 20:59:22.393
QueryHash
0x0F2C0A8B6DAD9246
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.