SQL Server Performance

to improve performance

Discussion in 'Performance Tuning for DBAs' started by dhamu294, Apr 1, 2010.

  1. dhamu294 New Member

    We have wrote an sp to get zero price records. It will first check in Account table for active account. then in pricehistory table and it will compare in position table, audit table . getting this records took 20 min for me.
    size of table
    Account 500000
    position 20000000
    audit 20000000
    pricehistor 30000000
    How to improve the performance.
    dhamu294, Apr 1, 2010
    #2

  2. Adriaan New Member

    You're presenting us with a black box, so we can't make any suggestions.
    Show us the sp code.
    Adriaan, Apr 1, 2010
    #3

  3. Fhatuwani New Member

    Are there and clustered indexes defined on the tables?
    Fhatuwani, Apr 7, 2010
    #4

  4. FrankKalis Moderator

    In order to receive good answers you need to provide more information.
    FrankKalis, Apr 7, 2010
    #5

Share This Page