Does the rowlock hint during an insert make the insert slower?

• namrata.dhanawade-1143388

  Ten Centuries

  Points: 1269

  More actions

  January 27, 2010 at 3:58 am

  #74587

  I have an SP that has a performance issue when a large number of rows are passed in.

  Two tables into which data needs to be inserted have a rowlock on them.

  Does this in any way affect the speed of the query?