Star Join Optimisation in SQL 2008 - Prerequisites?

To use star join, indexes are required on tables. FK constrants are not necessary, but it is recommended that you have FK contraints defined since without it SQL Server must depend on heuristics to detect star schema query patterns. There are some restric

social.technet.microsoft.com