title: Are computed columns in a view persisted?
body: <pre><code>CREATE VIEW [dbo].[MyView] ([ID],[VisitDate],[StartDate] ,[EndDate])
  WITH SCHEMABINDING  
  
      AS
      SELECT     id, VisitDate,dateadd(dd,-10,VisitDate)persisted,
         dateadd(dd,10,VisitDate)persisted
      FROM         dbo.Visits
  </code></pre>
  
  <p>I have a non-clustered index on ID and VisitDate.I wantd to know if the computed columns StartDate and Enddate is persisted or is it calculated runtime when view is referenced</p>
  
  <p>EDIT:<strong>what if i have a unique clustered index on ID and VisitDate.In that case will these columns become persisted?</strong></p>