How to Improve the perforamce of large tables ?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Performance Tuning » How to Improve the perforamce of large tables...

How to Improve the perforamce of large tables ?

Rate Topic

Display Mode

Topic Options

Author

Message

kbhanu15

Posted Wednesday, December 12, 2012 3:29 AM

Say Hey Kid

Group: General Forum Members
Last Login: Monday, January 21, 2013 11:26 PM
Points: 688, Visits: 72

Hi All,

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

Thanks
Bhanu

Post #1395553

John Mitchell-245523

Posted Wednesday, December 12, 2012 3:43 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:14 AM
Points: 4,428, Visits: 7,196

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

Post #1395559

Bhuvnesh

Posted Tuesday, January 22, 2013 12:42 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1409838

« Prev Topic | Next Topic »

Permissions