Skills
.Work. You
Rest

Configure SQL Performance Options

Community

Optimize SQL query performance.

Software Engineering#performance#database#optimization#sql#query tuning#intersystems iris
Authorsorodriguezz
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill addresses the challenge of slow-performing SQL queries by providing tools and techniques to configure and optimize performance settings within the InterSystems IRIS environment.

Core Features & Use Cases

  • Parallel Query Processing: Configure system-wide or per-query parallel execution to leverage multi-processor systems for faster query completion.
  • Runtime Plan Choice (RTPC): Enable dynamic query plan optimization based on runtime data, improving performance for queries with outlier values.
  • Frozen Plans: Manage query execution plans to maintain performance stability across system upgrades or configuration changes.
  • Use Case: A database administrator needs to speed up a critical reporting query that currently takes several minutes to run. By configuring parallel query processing and potentially freezing the optimized plan, they can significantly reduce the report generation time.

Quick Start

Configure system-wide parallel query processing by setting the auto parallel option to enabled.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: Configure SQL Performance Options
Download link: https://github.com/sorodriguezz/skills-objectscript/archive/main.zip#configure-sql-performance-options

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.