database-indexing-strategy

SKILL.md

Design comprehensive indexing strategies to improve query performance, reduce lock contention, and maintain data integrity. Covers index types, design patterns, and maintenance procedures.

❌ Don't create too many indexes (write performance impact) ❌ Don't create indexes without testing first ❌ Don't ignore index size and storage impact ❌ Don't forget to update table statistics after bulk operations ❌ Don't create duplicate indexes

✅ DO create indexes on foreign keys ✅ DO test index impact on INSERT/UPDATE performance ✅ DO use covering indexes for common queries ✅ DO drop unused indexes regularly ✅ DO monitor index fragmentation

데이터베이스 인덱싱 전략을 설계하고 구현합니다. PostgreSQL 및 MySQL에서 인덱스를 생성하거나, 인덱스 유형을 선택하거나, 인덱스 성능을 최적화할 때 사용합니다. 출처: aj-geddes/useful-ai-prompts.

원본 보기