/SqlIndexAdvisor
Designs optimal B-tree, GiST, or GIN composite indexes for heavy filter and sort queries while measuring write overhead and disk bloat.
Databases & SQL🔴 Advanced#sql#index
Databases & SQL
186 commands · 3 subcategories
Subcategories
Popular in Databases & SQL
/PgExplainAnalyze
Breaks down complex PostgreSQL query plans, flags hidden sequential scans, nested loop bottlenecks, buffer cache misses, and generates targeted index recommendations.
Databases & SQL🔴 Advanced#postgres#explain
/SqlDatabaseMigration
Generates expand-and-contract migration scripts (PostgreSQL/MySQL) for renaming columns, adding non-null columns, and splitting tables without table locks.
Databases & SQL🔴 Advanced#sql#migration
/ParameterizeAggregateQuery
Parameterize and secure against injection an aggregation query — e.g. total revenue by region and month.
Databases & SQL🟢 Beginner#aggregate#groupby
/DocumentEcommerceSchema
Write data-dictionary documentation for an e-commerce database schema — e.g. products, orders, customers and inventory tables.
Databases & SQL🟢 Beginner#ecommerce#schema
/CostProductionCluster
Review and reduce the running cost of a production database cluster — e.g. a Postgres cluster serving a checkout system.
Databases & SQL🟢 Beginner#cluster#production