SQL Server Performance

Use of Truncate command in Stored procedure..

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by Ritu, Mar 30, 2008.

  1. Ritu New Member

    Hi,
    In a Stored procedure , I am inserting rows in a temporary table does not having any index.
    If I issue Truncate Command on this temporary table . Does it cause recompilation of Store procedure ?
    Thanks in Advance!!
    Ritu, Mar 30, 2008
    #2

  2. madhuottapalam New Member

    I don't think so. I tested in 2005 and truncate is not a cause of recompilation of sp. It may be because of statement level recompiliation feature of sql server 2005. Coluld u pse confirm how about in SQL Server 2000
    Madhu
    madhuottapalam, Mar 30, 2008
    #3

  3. satya Moderator

    satya, Mar 31, 2008
    #4

Share This Page