PromptsVault AI is thinking...
Searching the best prompts from our community
ChatGPTMidjourneyClaude
Searching the best prompts from our community
Click to view expert tips
Specify framework versions
e.g., 'Next.js 14', 'Python 3.11' for accurate, up-to-date code
Request error handling & types
Ask for TypeScript definitions and try-catch blocks
Get step-by-step breakdowns
Request explanations before code for complex logic
Optimize a slow-running SQL query on a 50M+ row table. Techniques to apply: 1. Add appropriate indexes on WHERE and JOIN columns. 2. Replace subqueries with CTEs (Common Table Expressions). 3. Use EXPLAIN ANALYZE to identify bottlenecks. 4. Partition large tables by date for faster scans. 5. Rewrite correlated subqueries as window functions. Provide before/after execution times and explain each optimization decision.
A proven free prompt for SQL query optimization for large datasets is: "Optimize a slow-running SQL query on a 50M+ row table. Techniques to apply: 1. Add appropriate indexes on WHERE and JOIN columns. 2. Replace subqueries with CTEs (Common Table Expressions). 3. Use EXP..." — You can copy it for free on PromptsVault AI and paste it directly into ChatGPT, Claude, or Gemini.
Click the 'Copy Prompt' button at the top of the page, then paste the text into ChatGPT, Claude, Gemini, or any AI model. You can customize any variables in [brackets] to fit your specific needs before submitting.
Yes — this DATA SCIENCE AI prompt is 100% free on PromptsVault AI. No sign-up or payment required. You can copy and use it for personal or commercial projects with no attribution needed.
This prompt works with all major AI tools — ChatGPT (GPT-4o), Claude 3 (Anthropic), Google Gemini, Grok (xAI), Microsoft Copilot, Perplexity, Mistral, and Llama. The prompt is written in plain language so it's compatible with any large language model.