Thursday, February 16, 2012

average time of xcusion of a request sql

hi,
i m asking about : average time of xcusion of a request sql .
thks for help
The time of execution of a SQL request is really relative:
a query is well written and the design of the DB is good when the engine
satisfies the request with the minimum number of page reads. To examine the
behavior of the engine you should execute it under Query Analizer (SQL 2000)
or SSMS (SQL 2005) activating the I/O statistics:
set statistics io on
each query executed after this command will show useful information about
I/O counters.
Looking the statistics and the query plan you can undertand if your query is
working well or not
Gilberto Zampatti
"jomu" wrote:

> hi,
> i m asking about : average time of éxécusion of a request sql .
> thks for help
>

No comments:

Post a Comment