• If your goal in indexing is to try to make the clustered index the index used by most of your queries, you are doing it backwards. Clustered indexes are larger. and your queries will perform better, in general, when they use smaller non-clustered indexes.

    Also, let's suppose you base your clustering key on what certain queries are querying. Now fast forward a couple of years and you see that the queries hitting your system are completely different. Are you going to change your clustering keys? No, you may drop or add new nonclustered indexes but you don't change the clustering keys because a smart person doesn't base their clustering keys on the queries. The smart person bases it on the data. This is the general practice, there are always exceptions.

    Poor database design and indexing schemes like you are advocating are the reasons why applications like SharePoint, SCOM, and BizTalk have wild requirements like MaxDOP = 1 ... to cover up for their horrendous design.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]