Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning need one doubt clarification application team trying to execute a simple query RE: need one doubt clarification application team trying to execute a simple query
naga.rohitkumar
SSCertifiable
Points: 5557
More actions
November 26, 2012 at 12:17 am
#1562079
this is the query
select count(*) from acmt
when we execute this output has to display the records count in it
but some times it is taking 12 to 20 mins also actuall execution time is 2 to 10 secs
ThanksNaga.Rohitkumar