How to improve query performance in Stored procedure?

• nazrul choudhury

  SSC Rookie

  Points: 30

  More actions

  August 6, 2010 at 6:11 am

  #387516

  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.

• Claudiu Balciza

  SSC Enthusiast

  Points: 191

  More actions

  January 20, 2016 at 9:35 am

  #1853197

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