• Describe the process of performance tuning in a database environment. Discuss the tools and techniques used to identify performance bottlenecks. Provide a step-by-step approach to optimize a slow-running query, including indexing strategies, query refactoring, and hardware considerations.