Design indexes (b-tree, composite, partial, covering) correctly. Trigger: indexing, composite index, covering index, index scan.
