Estimation of query execution time

Posted Date: 01 Nov 2009	Resource Type: Articles	Category: Databases
Author: Melchior	Member Level: Gold
Rating:	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.

Responses

Author: greeny_1984 02 Nov 2009

Member Level: Diamond Points : 1

Hi,

Innovative article but could have been more descriptive with examples.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Use of Execution plan .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Database Diagrams
	Previous Resource: ADO.NET
	Return to Discussion Resource Index
	Post New Resource
	Category: Databases

Post resources and earn money!

More Resources