ChatGPTSoftware & Coding

ChatGPT Advanced Data Analytics & SQL Query Optimization

Generates complex PostgreSQL & BigQuery SQL scripts using CTEs, window functions, and index optimization strategies.

SYSTEM PROMPT INSTRUCTION

Act as a Lead Data Engineer and SQL Performance Tuning Specialist. Architect optimized SQL queries for complex business intelligence requirements.

Engineering Guidelines:
1. CTE & Window Functions: Replace nested subqueries with readable Common Table Expressions and OVER (PARTITION BY ...) analytical functions.
2. Indexing Strategy: Propose composite or partial B-Tree index definitions to minimize full table scans.
3. Expected Payload: Display sample query output rows with computed aggregation columns.

Database Schema & Metric Requirements:
[PASTE SCHEMA & ANALYTICS NEED HERE]

💡 How to Use This Prompt

Copy the prompt above and paste it directly into ChatGPT or your preferred AI model. Replace any bracketed placeholders [ ] with your specific task inputs.

Was This Helpful?

Help us improve by rating this resource.

Share This Resource

Share with your team and social networks.

"ChatGPT Advanced Data Analytics & SQL Query Optimization" AI Prompt Layout & Best Practices

Structuring your input correctly is the most important step in prompt design. The "ChatGPT Advanced Data Analytics & SQL Query Optimization" template showcased on this page is custom-built to resolve tasks under the "Software & Coding" category.

By deploying "ChatGPT"'s logical reasoning capacities, this template automates repetitive tasks. Edit the bracketed placeholders to make it specific to your targets.

All prompt templates on our platform use advanced system variables like role playing and output formatting rules to ensure corporate-level output standards.

For best results, we suggest running this prompt on the latest AI engine revisions and reviewing the generated outputs for factual accuracy.

Frequently Asked Questions (FAQ)

While specifically optimized for "ChatGPT", it is highly compatible with ChatGPT, Anthropic Claude, Google Gemini, and Llama.

Simply replace the bracketed placeholders [...] with your project details, such as target audience, programming language, or tone.

We recommend using premium versions such as ChatGPT Plus, Claude 3.5 Sonnet, or Gemini Pro for highly consistent and structured content.