How should Query Optimization be used in production for SQL Server?

Measure first, reduce unnecessary rows and columns, make predicates searchable, tune joins and indexes, and remeasure under realistic data volumes.