Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 6, 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
Posted Wednesday, January 20, 2016 9:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 26, 2016 11:43 AM
Points: 33, Visits: 53
in order to get some help you may need to post the table structures, the indexes and some info about the data distribution
Post #1754191
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse