SQL Server Performance

View Query

Discussion in 'General Developer Questions' started by amitm79, Mar 16, 2005.

  1. amitm79 New Member

    Hi All,
    Does anybody know what will be the impact if i modify the view definition while its being used by another process/connection.

    Regards,
    Amit
  2. satya Moderator

    I think there will not be any, until unless that changed view is executed next time the old plan will be in cache to process the tasks.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. Adriaan New Member

    Some client apps (esp. using ODBC connection) may be unpleasantly surprised, and need the link to the view to be refreshed. And of course if the client app refers to any column from the view that will now be dropped, you have another problem.

Share This Page