Vol. I · A Postgres HandbookTwelve chapters · · 756 queries

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

EasyPerformance & Indexes

Create a basic B-Tree index

SQL

CREATE INDEX idx_emp_last_name 
ON employees (last_name);

Tested against PostgreSQL 16

Note

“B-Tree is the default index type in PostgreSQL. Great for equality (=) and range queries (<, >, BETWEEN).