Analyze and optimize SQL queries for performance and readability.
#sql
#database
#performance
#optimization
Prompt
Analyze and optimize the following SQL query for [Database: PostgreSQL/MySQL/BigQuery].
Schema context:
[Describe relevant tables and indexes]
Query:
[Insert SQL Query]
Provide:
1. Explanation of what the query does
2. Performance issues identified
3. Optimized query with improvements
4. Recommended indexes
5. Estimated impact of changes
Customize
Fill Variables
Details
Model
GPT-4
Category
Development
Added On
Jul 15, 2024
Prompts are starting points. Review outputs before using them in production.