Post reply

hipotetic index?

  • August 14, 2008 at 3:18 pm

    #123022

    Hi!

    Why is the functionability of hipotetic index ?

    thanks

  • August 14, 2008 at 3:30 pm

    #858451

    A what? Do you mean hypothetical index?

    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

  • August 14, 2008 at 3:33 pm

    #858455

    sorry, but the word is:

    Hypothetical Indexes

  • August 14, 2008 at 3:40 pm

    #858461

    As far as I'm aware, they are used by the Database Tuning Advisor to help it estimate the effect that an index would have on a query.

    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

  • August 14, 2008 at 3:48 pm

    #858467

    ok, but this index is created physically occupy disk space?

  • August 15, 2008 at 12:09 am

    #858538

    Don't think so. I think it's just the metadata and some statistics of the index. The DTA's got some undocumented tricks that it uses when it tests queries out.

    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

  • August 15, 2008 at 8:40 am

    #858786

    🙁 I was hoping to learn a new word today!

    Chad

  • August 15, 2008 at 9:09 am

    #858807

    Chad Crawford (8/15/2008)

    🙁 I was hoping to learn a new word today!

    http://dictionary.reference.com/wordoftheday/

    😀

    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

  • August 15, 2008 at 9:31 am

    #858824

    sorry, my english is not good.

    thanks for yours comments.

Viewing 9 posts - 1 through 8 (of 8 total)

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