Skills
.Work. You
Rest

SQL Performance Overview

Community

Optimize SQL query performance.

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

System Documentation

What problem does it solve?

This Skill helps users understand and implement strategies to significantly improve the speed and efficiency of their SQL queries within the InterSystems environment.

Core Features & Use Cases

  • Query Optimization: Leverages InterSystems SQL's automatic query plan optimization and analysis tools.
  • High-Performance Tables: Guides on defining tables with optimized statistics, indexing strategies (standard, bitmap, bitslice, columnar), and storage layouts (row, column, sharded).
  • Configuration Tuning: Details on configuring parallel query processing, runtime plan choice, frozen plans, and optimization hints.
  • Use Case: A developer is experiencing slow query times on a critical report. They can use this Skill to understand how to analyze the query plan, define better indexes, and tune table statistics to speed up the report generation.

Quick Start

Use the SQL Performance Overview skill to learn about defining high-performance tables.

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: SQL Performance Overview
Download link: https://github.com/sorodriguezz/skills-objectscript/archive/main.zip#sql-performance-overview

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.