• 3312K still isn't huge - only 414 pages. But best advice is to make sure every table has a clustered index, with exceptions to that rule clearly documented. Make sure you choose your clustering key carefully. There are whole blogs and articles on that subject, so I won't repeat it all here.

    John