title: SQL Server view running slowly
body: <p>Before you read this, I have to mention that my question is different to <a href="https://stackoverflow.com/questions/806015/sql-query-joins-multiple-tables-too-slow-8-tables">this question</a>. Please don't consider it as similar question.
  I have a view in SQL Server like this:</p>
  
  <pre><code>Select 
      field1, field2 , ... (About 150 columns)
  From 
      Orders O
  Inner Join 
      Customers C on C.sustomerID = O.CustomerId 
  Inner Join 
      ... (about 20 more inner joins &amp; left joins)
  </code></pre>
  
  <p>Then my web page calls this big query (sp) and takes about 1 minutes to return the data. </p>
  
  <ul>
  <li>All tables are indexes carefully </li>
  <li>All foreign keys and relations set properly </li>
  </ul>
  
  <p>but it runs slowly. I've tried to convert it to an "Indexed View" based on this <a href="https://docs.microsoft.com/en-us/sql/relational-databases/views/create-indexed-views" rel="nofollow noreferrer">Microsoft article</a> but it does not work because of limitation of using left joins in indexed views. </p>
  
  <p>Any solution to have a faster view?</p>