Data & AnalyticsTechnologyPlatinum

Optimize database queries for better performance.

Database Indexing Strategist

PostgreSQL, MySQL, Index Optimization

advancedv5.0

Best for

▸Designing composite B-tree indexes for PostgreSQL queries with WHERE, JOIN, and ORDER BY clauses
▸Analyzing EXPLAIN ANALYZE output to identify missing or inefficient indexes
▸Optimizing write-heavy workloads by removing redundant indexes and minimizing write amplification
▸Implementing specialized indexes (GIN, GiST, BRIN) for JSONB, full-text search, and time-series data

What you'll get

▸CREATE INDEX statements with detailed column ordering rationale based on equality-range-sort principles
▸Index impact analysis showing estimated storage overhead and write amplification factors
▸EXPLAIN plan interpretation highlighting why specific scans occur and how proposed indexes resolve bottlenecks

Expects

Query patterns, EXPLAIN output, table schemas, and workload characteristics (read/write ratios, data volumes, growth patterns).

Returns

Specific index creation statements, index strategy recommendations with rationale, and performance impact analysis including write overhead estimates.

What's inside

“You are a Database Performance Engineer. You design and deploy indexes to optimize query performance while minimizing write overhead and storage cost. - **Evidence-based:** Analyze EXPLAIN plans and production metrics before recommending changes, never intuition. - **Workload-specific:** Tailor inde...”

Covers

What You Do DifferentlyMethodologyWatch For

Not designed for ↓

×NoSQL database indexing (MongoDB, Cassandra, DynamoDB)
×Query syntax debugging or SQL writing assistance
×Database schema design or normalization decisions
×Database migration planning or execution

SupaScore

89.05▼

Research Quality (15%)

9.1

Prompt Engineering (25%)

8.95

Practical Utility (15%)

8.8

Completeness (10%)

8.9

User Satisfaction (20%)

8.9

Decision Usefulness (15%)

8.75

Evidence Policy

Standard: no explicit evidence policy.

database-indexingpostgresqlmysqlquery-optimizationexplain-analyzeb-treegin-indexperformance-tuningindex-maintenancecovering-indexpartial-indexdatabase-performance

Research Foundation: 8 sources (1 industry frameworks, 3 official docs, 4 books)

This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.