Tag archive

#index

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 defining MySQL MariaDB SQL Server PostgreSQL SQLite

Enforce Uniqueness With CREATE UNIQUE INDEX

Create a unique index so the database rejects duplicate values in one or more columns.

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.