Text & chatAnalyse

Optimise a query using execution evidence

Improve a query based on execution evidence.

What to provide

Query
Execution plan
Table statistics

Make it yours

Fill in what you know. Empty fields stay as placeholders.

Query

Supply query for this task.

Execution plan

Supply execution plan for this task.

Table statistics

Supply table statistics for this task.

Optional instructions

Plain languageSource onlyShow uncertainty

Your prompt

Analyse [query], [execution plan] and [table statistics]. Identify bottlenecks and propose targeted changes with expected trade-offs. Explain how to compare execution time, reads and result equivalence before adopting them.

3 inputs to replace

How to use this prompt

Provide the actual plan, relevant statistics and a representative workload.

What to check in the result

Compare result equivalence, execution time and reads before adopting a change.

Technology, explained

Ideas into practice

Optimise a query using execution evidence

What to provide

How to use this prompt

What to check in the result