This post covers narrowing SELECTs, using proper joins, buffering where appropriate, and leveraging secondary indexes and table statistics. Use SQL trace (ST05) and runtime analysis (SAT) to find hotspots and validate improvements.