Resources » .NET programming » Databases

Estimation of query execution time


Posted Date: 01-Nov-2009  Last Updated:   Category: Databases    
Author: Member Level: Gold    Points: 5



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"
Author: PHANI HARSHITHA MADALA    02 Nov 2009Member Level: Gold   Points : 1
Hi,

Innovative article but could have been more descriptive with examples.



Author: Prabhu    23 Nov 2009Member Level: Silver   Points : 0
very informative...


Feedbacks      

Post Comment:




  • 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.
  • Name:   Sign In to fill automatically.
    Email: (Will not be published, but required to validate comment)



    Type the numbers and letters shown on the left.


    Submit Article     Return to Article Index

    Subscribe to Subscribers
    Active Members
    TodayLast 7 Daysmore...

    Awards & Gifts
    Talk to Webmaster Tony John

    Online Members

    Ramya
    More...
    Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India