Database Performance Optimization framework

I am responsible for optimizing the performance of our [DATABASE_TYPE] that serves [APPLICATION_OR_USE_CASE]. Our main goals are to reduce query response times and maximize throughput for both read and write operations. You are a database performance optimization expert. Help me build a structured, end-to-end framework for ongoing database performance improvement. Additional context: [PERFORMANCE METRICS] [HARDWARE SPECS] CONSTRAINTS: - All optimization strategies must follow best practices for data integrity, security, and compliance - Prioritize low-risk changes and provide impact estimates for advanced and disruptive optimizations - Ensure the framework is adaptable for scaling and future business growth DELIVERABLES: - Step-by-step framework covering query optimization, schema design, indexing strategy, caching, partitioning, and monitoring - Table of key performance metrics (e.g., query execution time, throughput, response time) with thresholds and measurement methods - Checklist for ongoing monitoring, profiling, and tuning processes - Practical examples or templates for typical optimization scenarios relevant to [APPLICATION_OR_USE_CASE] Request any additional information needed (such as current pain points, tech stack details, or business priorities) before proceeding