title: How to index views with left outer join in SQL Server
body: <p>I have created a view which is using <code>LEFT OUTER JOIN</code> in SQL Server.</p>
  
  <p>I am unable to index the views because you cannot put an <code>Index</code> on a view with an <code>OUTER JOIN</code>.</p>
  
  <p>Any alternatives?</p>