Post reply

How to Improve the perforamce of large tables ?

  • December 12, 2012 at 3:29 am

    #286084

    Hi All,

    Please give your valuable suggestions on how can i improve the performance of tables which having 2 crores of data.

    Thanks

    Bhanu

  • December 12, 2012 at 3:43 am

    #1567795

    Tables don't perform - queries do. But make sure you have the correct indexes and statistics set up on the tables, and that those indexes are maintained and statistics updated regularly. And review any queries that run against the tables to make sure they written optimally. You might also want to think about partitioning.

    John

  • January 22, 2013 at 12:42 am

    #1579463

    kbhanu15 (12/12/2012)

    Hi All,

    Please give your valuable suggestions on how can i improve the performance of tables which having 2 crores of data.

    Thanks

    Bhanu

    have you made any changes with this regard ? or it was just an interview question ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Viewing 3 posts - 1 through 2 (of 2 total)

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