Founding rate: RM5 off Basic, forever — applied automatically. See pricing

mahir_data
Menu▾
← All topics
ENBM
Log masuk

Topic

Indexing

What an index actually buys you, read straight off a query plan — and what it costs on every write. The recurring trap is treating an index as free, or assuming one exists just because a column looks like it should have one.

New to this? Read the free Indexes chapter.

mediumEnforce uniqueness the way a UNIQUE constraint actually worksFree→mediumIndex a foreign key column Postgres never indexed for youFree→hardGet the column order right on a composite indexFree→