How to improve query performance in Stored procedure?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Paul Clancy » How to improve query performance in Stored...

How to improve query performance in Stored procedure?

Rate Topic

Display Mode

Topic Options

Author

Message

nazrul choudhury

Posted Friday, August 06, 2010 6:11 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 4:20 AM
Points: 3, 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 »

Permissions