Database structure
Table definitions
Column types, keys, and relationships help prevent unsuitable index advice.
No table definitions added yet.
SQL Query Analyzer
AI-assisted review only. Your query is sent securely to the configured AI provider for analysis. It is never executed or saved by StarAssist. Do not include passwords, connection strings, or private data.
Choose a version when you know it. The analyzer will explain any assumptions it has to make.
Add table details or an error message Optional
Open this only when the query refers to tables the analyzer cannot see, or SQL Server has already returned an error.
Paste relevant CREATE TABLE scripts.
Paste the exact message SQL Server returned.
Ctrl/⌘ + Enter
Analysis result
Optional next step
Want to understand actual performance?
Run the quick review first, then add only the database evidence you have. Your query stays filled in and is never executed by StarAssist.
Guided performance check
What problem are you trying to solve?
Choose one goal. We will show only the evidence that helps with it.
Step 2
Add the evidence you have
Each item includes simple collection steps. You can skip optional items.
Recommended
Execution plan
Shows how SQL Server intends to access, join, sort, and aggregate the data.
- Open the same query in SQL Server Management Studio (SSMS) or another SQL Server client.
- Run the copied estimated-plan helper. It creates a plan without executing the query.
- Save the plan as
.sqlplan, then upload it here.
Need a more accurate actual plan?
An actual plan includes runtime information but executes your query. Use it only in an authorized, safe environment—especially for UPDATE, DELETE, INSERT, MERGE, or other data-changing statements.
Runtime evidence
I/O and timing
Shows page reads, CPU time, and elapsed time from SQL Server.
This runs your query. Copy the helper only when running the query is safe and authorized in your SQL Server environment.
- Copy the ready-to-run helper containing your current query.
- Run it in SSMS or another SQL Server client.
- Copy the Messages output and paste or upload it below.
This query may change data or execute code. Copy a helper that runs it?
Read-only helper
Indexes already on these tables
Prevents duplicate or conflicting clustered, nonclustered, composite, and included-column advice.
- Copy the metadata helper prepared for tables found in your query.
- Run it in the correct database. It reads metadata only.
- Copy the result grid with column headers and paste or upload it below.
Live snapshot
Blocking and waits
Shows which active sessions are waiting and what may be blocking them.
Timing matters. Run this read-only helper while the blocking problem is happening. Your DBA may need to grant permission to view server activity.
- Copy and run the blocking snapshot helper in the affected database.
- Copy the result grid with column headers.
- Paste or upload it below.
Quick choices
How is this query used?
This context helps rank recommendations without asking you to write a technical explanation.
Evidence is read in your browser and sent for analysis only when you choose Run performance review. Execution plans can contain database names, object names, and parameter values—remove anything sensitive first.