query Exec time?

Why would the same have different run time...less than 5 sec vs more than a
minute.Arul,
Same ? Check the Execution Plans for the queries. Also, ensure it is not
related to the data coming from disk on the first run data coming from
memory on the second run. See:
DBCC DROPCLEANBUFFERS
Stored procedures? Possible recompiles.
More info would help.
HTH
Jerry
"Arul" <Arul@.discussions.microsoft.com> wrote in message
news:9657DDF8-08BA-4908-8FC9-DB2DA5856D43@.microsoft.com...
> Why would the same have different run time...less than 5 sec vs more than
> a
> minute.