15 People are following this question.
How not to lose a clustered index advantage
You need to minimize the amount of time required for queries that use data from TBL1 and TBL2 to return data. What should you do?
What's the difference between a heap and index-organized table?
Retreive one record per contract year per ID