PromptGalaxi
💻 Software & APIschatgpt

SQL: explain plan walkthrough for analysts

Turn EXPLAIN output into plain-language bottlenecks and index ideas.

👁 22 المشاهدات📦 0 المشتريات
SQLperformanceanalytics

مجاني

شراء لمرة واحدة · وصول فوري

Sign in required to purchase

مباع من قبل

الوصف

Paste dialect, query, and plan. Get sequential steps, likely bottleneck, and safe next experiments (no destructive commands assumed).

مثال على المخرجات

1) Nested loop on … 2) Seq scan on large table … Suggestion: composite index on (a,b) — verify cardinality…

محتوى الطلب

Dialect: {{SQL_DIALECT}}

Query:
```sql
{{QUERY}}
```

EXPLAIN (or EXPLAIN ANALYZE) output:
```
{{PLAN}}
```

Explain to a data analyst (not a DBA):
1) Execution story in 5–8 bullets (order of operations).
2) Likely bottleneck with evidence from the plan.
3) 3 optimization ideas: index candidates (with columns), rewrite ideas, stats/maintenance notes — mark "verify with DBA" where needed.
4) What *not* to do (common mistakes).

If the plan is missing, say what to capture next.

مراجعات (0)

No reviews yet. Be the first to review this prompt!

طلبات مشابهة

💼
chatgpt

Sprint retro: facilitation guide + board template

Timed agenda, prompts, and actions with owners for remote teams.

agileretrofacilitation
0 purchases
$2.49
🎨
chatgpt

Twitter/X thread from one thesis

Hook, 8–12 posts, CTA, and hashtag discipline.

socialthreadthought-leadership
0 purchases
Free
📝
chatgpt

Newsletter issue: curated links + commentary

Hook, 4–6 link blurbs with takeaways, and sign-off matching your voice.

newslettercurationeditorial
0 purchases
Free