How to partition data of huge table

• av.abhishek

  Grasshopper

  Points: 13

  More actions

  October 4, 2012 at 11:05 am

  #263413

  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.

• Rajat Jaiswal-337252

  SSCommitted

  Points: 1779

  More actions

  October 7, 2012 at 12:24 pm

  #1546509

  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.