A SQL query scans many columns and rows but the consumer needs only two columns for one date. Which change should be evaluated first?

Published
  1. Add SELECT * to preserve every field
  2. Sort all historical rows before filtering
  3. Project required columns and apply a selective date predicate
  4. Remove the date predicate

Comments — 0