Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Update table using CTE or using inner query on same table RE: Update table using CTE or using inner query on same table

  • July 30, 2015 at 6:33 am

    #1816084

    Please examin query plans for all three queries above. Most probably you will not find the difference concerning perfomance.

    Optimizer always tries its best to utilize PK index, you needn't to force server to utilize it.