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.