Tag archive

#performance

Commands grouped around the same concept, pattern, or recurring problem.

4 commands with this tag Browse related patterns quickly

advanced performance SQL Server PostgreSQL SQLite

Create a Partial (Filtered) Index

Index only the rows that satisfy a `WHERE` condition using `CREATE INDEX ... WHERE condition`, shrinking the index and speeding up queries that always filter on the same predicate.

intermediate performance MySQL MariaDB SQL Server PostgreSQL SQLite

Inspect A Query Plan With EXPLAIN

Ask the database how it plans to execute a SELECT so you can understand scans, joins, and index usage.

intermediate defining MySQL MariaDB SQL Server PostgreSQL SQLite

Remove an Index With DROP INDEX

Drop an index that is no longer useful so writes no longer have to maintain it.

advanced defining MySQL MariaDB SQL Server PostgreSQL SQLite

Speed Up Queries With CREATE INDEX

Create an index on one or more columns to make lookups and joins faster.