Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2015
    Posts
    1

    Lightbulb Unanswered: Execution Plan Recompile

    Hi,
    I have a table with all NVARCHAR columns and i have an procedure which manipulates that table data. But in my sp i have declared all the variables in VARCHAR data type only. Now how the execution plan will be created? after sometime i will be changing my procedure in NVARCHAR data type variables. After changing it to NVARCHAR type, will the same execution plan get executed or it will create new execution plan?? Because there is no change in any query. Just changing the data type from VARCHAR to NVARCHAR.

    Regards,
    Karthik

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Fortunately for you, the table has the datatypes with the wider domain. You should see minimal changes in the query plans. If this was the other way around (table with varchar, and variables defined as nvarchar), you would have seen implicit conversions peppered in the query plan.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •