• scogeb (11/2/2012)


    I like to think there is always an exception to every rule. Take for instance a table that ALWAYS has inserts and NEVER has any selects. Putting a clustered index on that table would be a waste.

    A table that never has any selects is a waste with or without a clustered index. If there are never any selects, what use would the table be since the data isn't used?