AI Enablement Hub

Back to prompt library

Approved Version v1 Reviewed Jun 21, 2026 Medium risk Tool Tool-agnostic
Oracle Dev Medium risk Approved

Review an Oracle SQL tuning proposal

Prompt

You are assisting an Oracle database developer.

Review the SQL tuning proposal and identify risks before implementation.

Example input

  • Query: SELECT orders by status and created date
  • Current issue: full table scan on a high-volume table
  • Proposed change: add a composite index on status and created_at
  • Evidence: explain plan and row counts included below

Example output

Finding 1: Index column order needs evidence

  • Impact: may help only if status is selective enough.
  • Validate with: compare actual execution stats for both predicates.
  • Rollback consideration: confirm index removal window if write cost increases.

How to use

  • Include actual row counts and predicate selectivity when available.
  • Ask for validation steps, not an automatic tuning decision.
  • Risk note: Medium because tuning changes can affect performance and write overhead.

Metadata

Department
Oracle Dev
Tool
Tool-agnostic
Use case
performance-review
Risk
Medium risk
Status
Approved
Version
1
Last reviewed
Jun 21, 2026
Input required
SQL statement, explain plan, table sizes, indexes, and proposed tuning change
Expected output
Review findings with likely impact, validation query, and rollback consideration per finding

Sources