Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Is there any way to improve statistics on a table like this? RE: Is there any way to improve statistics on a table like this?

  • May 12, 2014 at 3:55 pm

    #1712869

    It's odd how SQL Server sometimes recommends an index that already exists. :crazy:

    If that's a very common set of queries, I'd drop the index that contains only the ParentID and add an index that has the ParentID and INCLUDE the Name column. From the looks of things, I'd be tempted to drop the index on the NAME column but I don't know how often it's used.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)