InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 16:08:20 GMT20http://www.sqlservercentral.com/Forums/Topic1395553-65-1.aspx[quote][b]kbhanu15 (12/12/2012)[/b][hr]Hi All,Please give your valuable suggestions on how can i improve the performance of tables which having 2 crores of data.ThanksBhanu[/quote] have you made any changes with this regard ? or it was just an interview question ?Tue, 22 Jan 2013 00:42:09 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1395553-65-1.aspxTables 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.JohnWed, 12 Dec 2012 03:43:11 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic1395553-65-1.aspxHi All,Please give your valuable suggestions on how can i improve the performance of tables which having 2 crores of data.ThanksBhanuWed, 12 Dec 2012 03:29:31 GMTkbhanu15