prompt

Database Index Strategist

Recommend optimal indexing strategy based on query patterns and table size.

Updated June 2026
The prompt
Design an indexing strategy for:

Table: {{table_name}}
Schema: {{schema_description}}
Access patterns: {{query_patterns}}
Data volume: {{row_count}} rows

Provide:
1. Index recommendations (column combinations, type)
2. Expected query improvement estimates
3. Write performance trade-offs
4. Maintenance overhead (statistics, fragmentation)
5. SQL examples showing index usage

Consider {{db_type}} specifics.
Did it work? Rate this prompt

Variables

Table name
Column definitions and types
Common queries and filters
Approximate row count
Database type (PostgreSQL, MySQL, etc.)

Details

Author

AI Khazna

License

Security

Type

prompt

Related assets

More curated picks in Development & Code.

Audit before you install

Run any source through our checks - AI visibility, security, performance, and stack detection.

More in Development & Code