skills.rest
sorodriguezz
sorodriguezzCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

Examine Query Performance

Analyze SQL statements and runtime statistics to diagnose query performance in InterSystems IRIS.

Updated Feb 2, 2026
Search Tags:#performance#query optimization#database#analysis#sql#iris
One-click install
npx skills add https://github.com/sorodriguezz/skills-objectscript --skill examine-query-performance
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Examine Query Performance
Source: https://github.com/sorodriguezz/skills-objectscript/tree/main/skills/examine-query-performance
Command: npx skills add https://github.com/sorodriguezz/skills-objectscript --skill examine-query-performance

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps users understand and improve the performance of their SQL queries by analyzing SQL statements and runtime statistics.

Core Features & Use Cases

  • SQL Statement Analysis: View and analyze recorded SQL statements, including their associated query plans and execution statistics.
  • Performance Tuning: Identify slow or frequently executed queries to optimize database performance.
  • Use Case: A developer needs to diagnose why a specific report is loading slowly. They can use this Skill to examine the SQL statements generated by the report, check their execution plans, and identify bottlenecks.

Quick Start

Examine the performance of SQL statements related to the 'Customer' table.

Frequently Asked Questions about Examine Query Performance

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I analyze SQL query performance in InterSystems IRIS?▼

To analyze SQL query performance in InterSystems IRIS, you can examine recorded SQL statements alongside their runtime statistics. This process diagnoses slow operations by reviewing query plans, execution counts, and timing metrics to identify bottlenecks.

What is SQL query optimization and how do execution plans help?▼

SQL query optimization improves database efficiency by identifying slow or frequently executed operations. Execution plans provide detailed insights into how queries run, helping you pinpoint inefficient SQL statements and performance bottlenecks for targeted tuning.

How do I identify slow SQL statements and diagnose bottlenecks in a database?▼

You identify slow SQL statements and diagnose bottlenecks by analyzing runtime statistics and execution counts. Reviewing comprehensive query plans helps locate inefficient database operations causing performance issues during tasks like loading reports.

Can I use SQL performance analysis to troubleshoot a slow loading report?▼

Yes, you can troubleshoot a slow loading report by examining the generated SQL statements. By checking their execution plans and runtime statistics, you can identify the specific query bottlenecks causing the delay and optimize them.

What is the best way to view runtime statistics for SQL statements?▼

The best way to view runtime statistics for SQL statements is to analyze the recorded execution data. This includes examining execution counts and timing metrics, which facilitates comprehensive performance data analysis for tuning.

Related Skills

Explore More Software Engineering Skills→
sorodriguezzsorodriguezz

How InterSystems IRIS Processes SQL Statements

Detail the internal SQL statement processing pipeline in InterSystems IRIS.

Community
Intermediate
iamBrzDeviamBrzDev
5

sqlserver-query-patterns

Optimize SQL Server queries, design indexes, and refactor stored procedures.

Community
Advanced
sorodriguezzsorodriguezz

Configure SQL Performance Options

Configures parallel query processing and runtime plan choice in InterSystems IRIS.

Community
Advanced
gemini-cli-extensionsgemini-cli-extensions
42

cloud-sql-postgres-monitor

Fetch PromQL metrics, EXPLAIN plans, and active queries for Cloud SQL PostgreSQL.

Official
Intermediate