Execution Plan?

The query that you run in any database server, comprises of multiple statements and operations like

SELECT, JOIN, DELETE, UPDATE.

When you run your query, database server engine breaks it into multiple parts and analyse it and find the most efficient way to execute your query to access data from and write data to database server.

Thus execution plans shows you how are query is being executed in server read or manipulate data to server. It shows you the cost of execution of query in terms of time and resources taken by different parts of the query. So if the total cost of query 100%, your select statement might be taking 30% and then JOIN statement will take rest of the 70% of the total cost if your query comprised of select and join statement.

for more info

https://www.simple-talk.com/sql/performance/execution-plan-basics/

http://www.codeproject.com/Articles/9990/SQL-Tuning-Tutorial-Understanding-a-Database-Execu

Please mark as accepted if found helpful

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Munesh Sharma10y ago
An Execution plan is a visual representation of the operations performed by the database engine in order to return the data required by your query.

http://www.sqlshack.com/sql-server-query-execution-plans-examples-select-statement/
0
Atul Kumar10y ago
The query that you run in any database server, comprises of multiple statements and operations like

SELECT, JOIN, DELETE, UPDATE.
When you run your query, database server engine breaks it into multiple parts and analyse it and find the most efficient way to execute your query to access data from and write data to database server.

Thus execution plans shows you how are query is being executed in server read or manipulate data to server. It shows you the cost of execution of query in terms of time and resources taken by different parts of the query. So if the total cost of query 100%, your select statement might be taking 30% and then JOIN statement will take rest of the 70% of the total cost if your query comprised of select and join statement.

for more info
https://www.simple-talk.com/sql/performance/execution-plan-basics/
http://www.codeproject.com/Articles/9990/SQL-Tuning-Tutorial-Understanding-a-Database-Execu

Please mark as accepted if found helpful
0