Post reply

Index tuning

  • April 7, 2009 at 8:09 am

    #130446

    I have a table with about 500,000 records, and it has 8 fields, one of which is a guid as the primary key (indexed, non-clustered). I have indexes on each of the fields, and when I select one row using any one of the fields, its fast, but the index plan is 51% on the index seek, and 49% on the bookmark lookup. Isn't this ineffcient? I believe this is causing problems in larger queries in other areas.... any ideas?

  • April 7, 2009 at 8:15 am

    #973392

    Do you have a clustered index?

  • April 7, 2009 at 8:24 am

    #973406

    There was no need to repost the question in this case. I have requested that the other one be moved to the 2000 forums.

    No replies to this thread please, direct replies to http://www.sqlservercentral.com/Forums/FindPost691625.aspx

    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

  • April 7, 2009 at 8:40 am

    #973431

    I tried that, but I couldn't see how thats done... is there a way I can move it? Or does it have to be done by an admin?

  • April 7, 2009 at 8:55 am

    #973454

    It has to be done by an admin. Use the Report button and request that the thread be moved.

    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 5 posts - 1 through 4 (of 4 total)

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