• This site (link) states that DB2 only guarantees that a clustered index is initially clustered, clustering is not maintained. While this saves time on inserts (no page splits), I'm glad SQL Server allows index fragmentation instead.

    Additionally, the MDC is primarily useful for low cardinality indices, which are not considered good candidates for a normal clustered index.

    I agree that there are situations where this option would be useful. Do you know if there's a request ticket on Connect for this feature?


    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.