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.