SQL Server Performance

Using temp table in place of cursor to loop

Discussion in 'T-SQL Performance Tuning for Developers' started by JLDominguez, Jul 6, 2005.

  1. JLDominguez New Member

    What is the real difference in performance between using a cursor and using a temp table to process records individually? Will there be a noticeable difference in performance between cursors or the use a temporary table? Most articales recommend using a temp table instead of cursor to loop through records. However, it appears to me that they are similar and would not provide a benefit. Unless the nature of a cursor intrinsically has more overhead? -Thx in advance
  2. dineshasanka Moderator

  3. FrankKalis Moderator

Share This Page