HomeToolsAbout

Index

Primary Keys are always indexed

In most SQL databases, Primary keys are automatically indexed.

Finding Indexes

SELECT tablename, indexname, indexdef FROM pg_indexes WHERE schemaname = 'public'

Create Index

CREATE INDEX index_name ON table_name (column1, column2, ...); CREATE INDEX idx_customer_name ON Customers (customer_name);
AboutContact