When the databases related to your applications, become more complex and get bigger data volume, you may face performance issues.
- Most of performance issues can be fixed by redesigning indexes. This option is a fast, efficient and low cost solution.
- Some performance issues will require to change your databases architecture. This option is longer to apply and much more costly as it may require to move databases or data, add new hardware and so on.
- Finally some performance issues will require to change your database design. This option could be even longer to apply at an enourmous cost as it will require to update and sometimes change or rewrite big chunks of your aplications.
To prevent option 2 and 3, database Architecture and Design need to be the first focus of a database related application development project.