A boolean by itself is often weak unless paired with something else or made partial.

Section: Anti-patterns

Be careful with low-cardinality flags

sql

-- Often weak by itself
INDEX (is_deleted)

-- Often better
INDEX (is_deleted, created_at)
-- or a partial index where supported

Explanation

A low-cardinality flag alone may still leave too much work for the engine.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Anti-patterns

Do not keep several indexes that serve the same leading prefix needlessly.

Open In sheetsqlsame section

Unused indexes still hurt writes and consume disk.

Open In sheettextsame section

Rebuild a problematic or bloated index.

Refresh optimizer statistics after big data shifts.

Compact the file after heavy changes when appropriate.