Defining a High-Performance Schema
CommunityOptimize SQL table performance with statistics.
Authorsorodriguezz
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses the challenge of ensuring optimal query performance in InterSystems SQL tables by explaining and demonstrating the use of table statistics.
Core Features & Use Cases
- Collected Statistics: Automatically gathered from data, refreshed periodically.
- Fixed Statistics: Manually set by developers for predictable query plans.
- Statistics Types: Covers Extent Size, Field Selectivity, Average Field Size, Outlier Selectivity, Map Size, and Histograms.
- Use Case: A database administrator can use this Skill to understand how to tune table statistics to significantly speed up complex reporting queries.
Quick Start
Use the defining a high-performance schema skill to learn how to set fixed statistics for a table.
Dependency Matrix
Required Modules
None requiredComponents
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: Defining a High-Performance Schema Download link: https://github.com/sorodriguezz/skills-objectscript/archive/main.zip#defining-a-high-performance-schema Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.