Estimation of query execution time
Estimation of query execution time:
The SQL query execution is based on two factors. They are
1) Formation of Execution plan and
2) Execution of query based on that execution plan
So the query execution time is based on the above two factors. The query execution time is calculated by summation of time taken to form execution plan and time taken to execute the SQL query based on that execution plan.
The mathematically representation of query execution time:-
Query Execution time = SUM (Time Taken to form Execution plan, Time taken to execute the query based on that execution plan).
The performance of query is not only depends on the design of the SQL query. It depends on the execution plan also.
So we should pay attention on the design of effective execution plan also.
Did you like this resource? Share it with your friends and show your love!
Responses to "Estimation of query execution time"
PHANI HARSHITHA MADALA
02 Nov 2009 Member Level:
Innovative article but could have been more descriptive with examples.
23 Nov 2009 Member Level:
Notify me by email when others post comments to this article.
Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
No HTML formatting and links to other web sites are allowed.
This is a strictly moderated site. Absolutely no spam allowed.
to fill automatically.
(Will not be published, but
to validate comment)
Type the numbers and letters shown on the left.
Last 7 Days
Awards & Gifts
Articles Rss Feeds
Forum Rss Feeds
Talk to Webmaster Tony John
Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India