Post reply

Index Size question

  • February 5, 2008 at 1:19 pm

    #178884

    Hello,

    I have a question about space used by a table index.

    The result returned by sp_spaceused is twice the value that is computed from the sysindexes table (used col).

    Why this discrepancy?

    Does this have to do with outdated statisitcs or updating stats on the tables with FULLSCAN ? (The indexes have not been rebuilt or updated in a long time).

    Is it okay to run update stats with fullscan during normal business hours?

    Thanks

  • February 5, 2008 at 11:31 pm

    #775434

    Please don't cross post. It wastes people's time and fragments replies. Most of he regulars here read all the forums

    Disscussions to the following thread please - Index size (Performance tuning)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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