Describe advanced techniques for optimizing database performance. Include indexing strategies, query plan analysis, memory configuration, I/O optimization, and database-specific tuning approaches. Explain how to identify bottlenecks through monitoring and apply systematic improvements without impacting availability.