Home Forums SQL Server 2008 SQL Server 2008 - General How many rows in a table before using a clustered index? RE: How many rows in a table before using a clustered index?

  • November 2, 2012 at 10:21 am

    #1555581

    GSquared (11/2/2012)

    GilaMonster (11/2/2012)

    Stewart "Arturius" Campbell (11/2/2012)

    Clustered indexes are best suited for those columns most frequently used in range-based searches.

    I would tend to disagree with that, but that's just me.

    Not just you.

    You have quite a community here 🙂

    To OP: Don't waste your time. Every permanent table in database better to have a clustered index. There are many reasons for that.

    Exceptions are very few: some times ETL processing staging table used mainly for inserts of large chunks and then truncated or even, better dropped, may not need clustered index...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]