How to improve query performance in Stored procedure?

  • 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.

  • in order to get some help you may need to post the table structures, the indexes and some info about the data distribution

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply