Post reply

Help in Tuning

  • June 5, 2008 at 2:57 am

    #192006

    Hi,

    I have a table with appr 10 million records.(history data)

    While trying to retrieve records with a max query it takes

    I have included indexes ; clustered index on the data but so far no partioning has been done

    Please let me know Will retieving data be faster if partioning is done?

    And also steps for the same ...

    Thanks!

  • June 5, 2008 at 11:22 am

    #824991

    You should post DDL of table, the query you are running and the indexes there.

    Without this it will be very difficult to help you.


    * Noel

  • June 5, 2008 at 3:36 pm

    #825152

    This is a duplicate thread. There are answers on the other copy (same forum).

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

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