📋 Full Prompt

Analyze and optimize the following SQL query: [query]. Assuming a large-scale data environment, identify the cause of performance degradation from an Execution Plan perspective and explain the improved query.

🏷️ Tags

#DB#SQL#performance optimization

💡 Usage Tips

✅Replace the variables in brackets ([]) with your specific situation.
✅Specify the desired tone and length of writing for more accurate results.
✅Request additional modifications based on the generated output to improve quality.
✅Specifying a particular audience allows AI to adjust vocabulary and explanation level.

🔗 Related Prompts

Clean Code Reviewer

Analyzes provided code for potential bugs, performance issues, and readability.

Automated Unit Test Generator

Analyzes function or class code and generates Jest/Pytest test code including edge cases.

Legacy Code Modernization (Refactoring) Expert

Cleans up old, complex code by applying modern best practices and design patterns.

API Documentation Designer (Swagger/OpenAPI)

Generates standardized OpenAPI Spec (Swagger) documentation based on endpoint design.

Effective Writing Strategies with AI

AI writing prompts let you efficiently produce blog posts, business emails, press releases, novels, and more. The key is to assign AI a precise role, and clearly specify the desired tone, length, and target audience. For example, requesting "write a 2000-word SEO-optimized blog post in a professional tone" yields significantly higher-quality output. After generating a draft, iterative feedback helps elevate the final quality step by step.

This prompt belongs to the Coding category, optimized for ChatGPT at a Advanced level. It is systematically designed applying core prompt engineering principles: role assignment, context setting, and constraints.

Explore More Prompts

Discover 90+ verified prompts in the PromptGenie library.

Browse Library