有哪些常用且有用的技术可以优化数据库性能？

I was wondering how we could usually optimize the database performance for a data intensive web application. Are there any common requirements like what queries to use, how to deal with relationships fast, whether to avoid writing to database as much as possible, etc. Anything related works.I was wondering how we could usually optimize t