SQL Server Query Optimization Rules of Thumb

Just came across this very helpful article.  The main highlights are at the bottom as follows…Good candidates for clustered indexes are:Primary keys of the lookup/reference/dimension/master tables Foreign keys of the fact/detail tablesDatetime fields of the tables queried by the date rangeOptimization Rules of ThumbAlways look at the query plan first. It will show you the optimal current