I'm generally a convert to the congragation that all tables should have clustered indexes. It makes sense, helps performance, and in most cases is the best starting point for a tables. If you aren't part of the community of the faithful on clustered indexes, please read Kimberly Trip's blog on clustered indexes. There are other … Continue reading Find The Heap Indexes