Composite clustered index ordering when inserting

  • GilaMonster (8/10/2010)


    Agreed, but since the rebuild recreates the entire index regardless of what state it's in, it shouldn't be affected by how fragmented the index is, whereas the reorganise likely will be. Rebuild's certainly more intense, not disputing that.

    That's a great point though. I know I won't get to it soon, but that's a great idea for a little bit of testing, just to know. It's just scary sometimes how smart you are about all this stuff.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Yes Celko, this is always a good point to have in mind. Thank you for this reminder!

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply