Post reply

Proper Indexing a table containing 200+ fields for better performance

  • September 1, 2009 at 4:37 am

    #156157

    Hi,

    I've been trying to increase performance on a singular table containing the following:

    1. Over 200 Fields

    2. Indexed on PK call ID

    3. Data table can contain 100,000

    4. Slow performance in Query Analyzer

    5. Table can not be changed

    How to increase performance? I added a non-clustered index on where clause candidates - did yield or increase performances.

    any thoughts

    Thanks,

  • September 1, 2009 at 4:49 am

    #1047397

    Hi ,

    there could be many reasons for this , take a look at this article on how to post specifics

    http://qa.sqlservercentral.com/articles/SQLServerCentral/66909/


    Clear Sky SQL
    My Blog[/url]

  • September 1, 2009 at 6:35 am

    #1047463

    From the info that you've given us, all I can suggest is to add indexes to support the queries. If you want more specific help than that, please post the queries that are slow, as well as the other required info as indicated in the article referenced above.

    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 3 posts - 1 through 2 (of 2 total)

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