Home Forums SQL Server 7,2000 Strategies "primary key" in Table Variable RE: "primary key" in Table Variable

  • November 10, 2008 at 6:09 am

    #896244

    China Satya Rao T (11/10/2008)

    In the execution plan, the cost of table variable population is 0.1%

    In the main query, cost of table scan on table variable is 0%

    The cost of operations against table variables cannot be considered accurate. Accurate costing requires that the optimiser knows how many rows will be affected and the optimiser cannot know that with table variables because they have no statistics.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass