Home Forums SQL Server 2008 SQL Server 2008 Administration Table has large amount of Data querry geting delayed RE: Table has large amount of Data querry geting delayed

  • December 18, 2012 at 12:58 am

    #1569397

    mpradeep23 (12/17/2012)

    Hi

    We have a table which contains allmost 1 lak to 2 lak of records

    querring on that table getting delayed give me idea how to make it faster

    Thanks in advance

    pradeep

    Hey Pradeep,

    As mentioned by Bhuvnesh, if you need help ,please provide more info like table DDL, sample records,query you are using, index on columns etc. Infact the more info you'll provide the better solution you'll get here.

    Anyway some folks have provided the urls for optimization on this forum.Please refer those.