title: How to get star query optimization in SQL Server 2005
body: <p>I have a star schema but SQL Server 2005 always uses the clustered indexes to access a table. What parameters do I have to set to enable this optimization. </p>
  
  <p>According to <a href="http://blogs.msdn.com/sqlqueryprocessing/archive/2007/04/09/how-to-check-whether-the-final-query-plan-is-optimized-for-star-join.aspx" rel="nofollow noreferrer">http://blogs.msdn.com/sqlqueryprocessing/archive/2007/04/09/how-to-check-whether-the-final-query-plan-is-optimized-for-star-join.aspx</a> and the DWH datasheet of SQL Server 2005 both claim, that SQL Server 2005 support this feature.</p>