Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to improve query performance in Stored procedure? Expand / Collapse
Author
Message
Posted Friday, August 06, 2010 6:11 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 4:20 AM
Points: 6, Visits: 32
How to improve query performance in Stored procedure?
My stored procedure is very slow while executing a query....
SELECT TOP 1 mydata
FROM tbl_DataMap A
INNER JOIN tbl_DataMap1 B
ON A.DataID= B.DataMap1ID
AND B.DataMapTeam= 5
WHERE DataMapID= TestObj.DataMapID

While executing this SP, it is taking more time around 30 sec. Is there any mistake that slowed down the query. Please help.


Regards,
Nazrul Choudhury.
Software Associate @ Synechron Technologies.
Post #965045
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse