Post reply

Help Performance Tune this Code please

  • March 2, 2009 at 7:42 am

    #951868

    just forgot to say, on the index code, client_id is the first column, the code I placed on my last post was copied from a previous post and not the actual DDL, I can confirm client_id and service_Date are two columns in that order.

    So the plan attached previously is based on this setup.

  • March 5, 2009 at 2:36 pm

    #954439

    Have you tried the single-table test?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

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