title: SQL Server 2008 - Understanding Indexed Views
body: <p>I want to try and understand what SQL Server 2008 is doing when an indexed view is created.</p>
  
  <p>Say I have the following:</p>
  
  <pre><code>CREATE View [vwCoaterC48] WITH SCHEMABINDING
  AS
  
  Select
      ID,
      equipment_id as EquipmentId,
      read_time as ReadTime,
      C48_R_Act_Temperature,
      C48_L_Act_Temperature,
      C48_C_Act_Temperature
  From dbo.td_coater_c48 c
  Where read_time &gt;= Convert(dateTime,'11/4/2011',120)
  
  CREATE UNIQUE CLUSTERED INDEX [IX_vwCoaterC48_ReadTime_EquipmentID_ID] ON [vwCoaterC48] 
  (
      [ReadTime] ASC,
      [EquipmentId] ASC,
      [ID] ASC
  )
  </code></pre>
  
  <p>Am I correct that SQL Server will create some sort of physical storage (table?, what?) for this. The physical storage, or table, will only contain rows where the read_time column is >= 11/4/2011, and a clustered index will exist on the columns indicated?</p>