提高数据库性能的最佳方法

I was recently in an interview and i have been asked a question that was : After one year of publishing your application the data in the database became massive , so what is the best way to optimize the DB performance in the DB side not in the coding side whether database is Oracle or SQL server ... i just want to know what is the best answer for this question ?I was recently in an interview and i have been