SQL Indexes

Database indexes — CREATE INDEX, UNIQUE INDEX, COMPOSITE INDEX, DROP INDEX. This category documents 30 SQL indexes entries, and each page gives you the full syntax, the parameter list, the return value, and a runnable example tested against MySQL, PostgreSQL, SQL Server, and SQLite. The entries are: CREATE INDEX, DROP INDEX, COMPOSITE INDEX, EXPLAIN, FULLTEXT INDEX, SPATIAL INDEX, INCLUDE INDEX (Covering Index), PARTIAL INDEX, INVISIBLE INDEX, CONCURRENTLY (CREATE INDEX), CLUSTERED INDEX, NONCLUSTERED INDEX, ALTER INDEX (REBUILD / REORGANIZE), UPDATE STATISTICS, Index with Included Columns (Covering), INDEX WITH FILLFACTOR, Index Scan vs Seek, Index Maintenance (Rebuild/Reorg), Index on Expression (Function-Based), Index Tuning Advisor, Index Covering Query, INDEX with WHERE (Filtered Index), Unique Index vs Unique Constraint, Index with SORT IN TEMPDB, INDEX ON PRIMARY KEY, SQL Server ALTER INDEX DISABLE, INDEX REORGANIZE vs REBUILD, COLUMNSTORE INDEX, SQL Clustered Index (InnoDB PK), INCLUDE Index (SQL Server/PG). Not sure where to start? CREATE INDEX and DROP INDEX are the most commonly used entries in this category. You can also search across every category from the search page, browse the complete A–Z index, or try any of these statements live in the SQL playground.