We are creating a large database with estimated growth rate 200 million+ records per annum. The database is use for analysis purpose and we will generate different tabular and graphical reports from available data. we've some concerns and require technical input and advices.
- What impact we may see in future for very large table? Is there any limitation on number of records in one table or size of table?
- What is the best way to index large data tables like this?
Any suggestion for optimization and performance of database is also appreciated.