Completely Free .NET word API

Resources » .NET programming » Databases

Estimation of query execution time

Updated: Category: Databases
Author: Member Level: GoldPoints: 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 2009   Member Level: Gold   Points : 1

Innovative article but could have been more descriptive with examples.

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


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

    Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India