title: How to speed up queries in Microsoft Dynamics CRM 2011
body: <p>I have a project to build reports using Microsoft Dynamics CRM 2011 &amp; SSRS. The recommended data source is filtered views. I have all queries for the reports using filtered views.</p>
  
  <p>I have discovered that filtered views are very slow; for instance, it takes more than 10 seconds to select top 1  * from [FilteredContact]. </p>
  
  <p>What are the best alternatives to this solution? </p>