Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to partition data of huge table Expand / Collapse
Author
Message
Posted Thursday, October 4, 2012 11:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, September 22, 2013 8:07 PM
Points: 1, Visits: 20
I have a table(T1) of around 20 million record and about to grow in future by 100 to 200%. It contains the Data for the respective day and on next day it will be stored into another table (backup tables (T1_Backup)). And the process continues.

My queries are
1) T1 table is used to generate report for the respective date. I am thinking to partition the table with respective to category column (which is varchar datattype).

2) T1_Backup table is also containing data of each date with category which grows rapidly. To retrieve data from the table it is consuming lot of time.

Let me know the process of partitioning with respective of category for T1 table and for T1_Backup wrt to date and category.


Post #1368590
Posted Sunday, October 7, 2012 12:24 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 1:28 AM
Points: 110, Visits: 332
Hi Abhishek,

I am assuming the mail target of this partition is to fetch the query fast.

So use those values which are frequently used in your Where clause.

You can use Date column or Year column also for this.
Post #1369554
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse