Diagnose and improve database query performance using workload evidence, execution plans, cardinality, I/O, round trips, contention, and application-level access patterns. Apply to slow, expensive, or scaling queries; preserve semantics and verify improvements under representative load.