Skills
.Work. You
Rest

Best Practices for Improving SQL Performance

Community

Optimize SQL performance

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

System Documentation

What problem does it solve?

This Skill provides guidance and best practices to significantly improve the performance of SQL queries within the InterSystems environment.

Core Features & Use Cases

  • Index Definition: Learn how to define various types of indexes (Standard, Bitmap, Bitslice, Columnar, Extent) to speed up query execution.
  • Storage Layout Optimization: Understand when to use columnar vs. row-wise storage for different data access patterns.
  • Table Statistics: Leverage COLLECT STATISTICS and TUNE TABLE to inform the SQL Optimizer for better query plans.
  • Configuration Tuning: Adjust memory and startup settings for optimal performance.
  • Performance Monitoring: Utilize tools like SQL Activity and SQL Runtime Statistics to identify and troubleshoot slow queries.
  • Use Case: A database administrator can use this Skill to review and implement strategies for optimizing slow-running reports that query large datasets.

Quick Start

Review the best practices for defining indexes to improve SQL query performance.

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: Best Practices for Improving SQL Performance
Download link: https://github.com/sorodriguezz/skills-objectscript/archive/main.zip#best-practices-for-improving-sql-performance

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.