SQL Query Optimization for Large Datasets
Create an optimization report using this Claude prompt for data analysts handling vast databases
CodingSQL Query Optimization for Large Datasets
Create an optimization report using this Claude prompt for data analysts handling vast databases
You are a world class database administrator, specializing in performance optimization for large datasets. Your expertise helps data analysts derive insights quickly and efficiently. [YOUR_PROJECT] needs to create a repo
Generates a structured report detailing SQL query optimizations tailored for large datasets.
Generates a structured report detailing SQL query optimizations tailored for large datasets.
How to use
- 1
Your SQL queries currently being executed and their execution plans
- 2
A profile of the dataset size and indexing strategies in use
- 3
Any reported performance issues or bottlenecks encountered
Frequently asked questions
What is the SQL Query Optimization for Large Datasets prompt used for?
Generates a structured report detailing SQL query optimizations tailored for large datasets.
How do I get the best results from this database & sql prompt?
Paste the prompt into Claude, GPT-4, GitHub Copilot, fill in every bracketed placeholder with your specific information, then submit. The more detail you add to each placeholder, the more targeted the output. You can continue in the same conversation to refine tone, length, or focus without restarting from scratch.
Does this prompt work with Claude?
Yes. This prompt is optimized for Claude and also works well with GPT-4 and GitHub Copilot. The structured format with a defined role and numbered steps produces consistent results across all major instruction-following models, so you can use whichever tool you prefer.
How do I access this coding prompt?
This database & sql prompt is available through TopFreePrompts with a Lucy+ licence. You can get access with a one-time Lucy+ purchase for $109, or a $15/month plan you can cancel anytime. Both options give access to the full library of 1,000,000+ prompts across all categories.
More Coding Prompts
View allData Validation Framework: ChatGPT, Claude, Gemini, Grok, Cursor Prompt
Automated Data Integration: ChatGPT, Claude, Gemini, Grok, Cursor Prompt
Data Cleaning Pipeline: ChatGPT, Claude, Gemini, Grok, Cursor Prompt
Data Cleaning Automation: ChatGPT, Claude, Gemini, Grok, Cursor Prompt
Automated Data Analysis Report: ChatGPT, Claude, Gemini, Grok, Cursor Prompt
Data Integration Techniques: ChatGPT, Claude, Gemini, Grok, Cursor Prompt
ETL Pipeline Development: ChatGPT, Claude, Gemini, Grok, Cursor Prompt
Automated Data Cleaning Workflow: ChatGPT, Claude, Gemini, Grok, Cursor Prompt
Batch Data Processing Workflow: ChatGPT, Claude, Gemini, Grok, Cursor Prompt
Automated Data Reporting: ChatGPT, Claude, Gemini, Grok, Cursor Prompt
Data Integration: ChatGPT, Claude, Gemini, Grok, Cursor Prompt
Data Analysis and Reporting: ChatGPT, Claude, Gemini, Grok, Cursor Prompt
Related Prompts
View all
Partial Progress Save and Restore Loop: Claude Code Prompt
Loop Circuit Breaker Pattern: Claude Code, Cursor Prompt
Loop Failure Recovery and Resume Pattern: Claude Code Prompt
Worktree Lifecycle Management: Claude Code, Cursor Prompt
Conflict-Free Multi-Agent Worktree Strategy: Claude Code Prompt
Rollback Trigger on Metric Degradation: Claude Code Prompt
Human Approval Gate Before Deploy: Claude Code Prompt
Multi-Stage Acceptance Criteria Checker: Claude Code Prompt
Incremental Processing State Tracker: Claude Code Prompt
Agent Progress Journal Pattern: Claude Code, Cursor Prompt
Loop State Persistence with File Checkpoints: Claude Code Prompt
Translation Update Orchestration Loop: Claude Code Prompt