I have InfoCube. I have hardly 50,000 records. shall i do partitioning right now, if so can i do same partitioning after 3 years when my data is 2 million records.
(ii) Can i use aggregates after 3 years for query performance.
<b> when , where and how i should choose between a partitioning/aggregates?</b>
Any how to documents/links would be really helpful. Pls mail to:- email@example.com
Thanks in advance!