I have very huge table ( 150 fields and 35 Million records), every month that table will grow up to 20 Gig.
Users will be running reports against this table with date range. I understand that I can partition this table according to the insert date, so that when a user runs a reports for period, we can get better performance. Also it will be easy for archiving.
What I don't know is, How I can better use of Index Partitioning?. Also I will be loading data once a week (8 million records / week). Currently we are dropping the index and loading the data and recreating the index.
Is there any other way to speedup the loading time?.
How can the Index Portioning will help in this manner?
Let me know
Thanks in advance