Database Design
	• Use Indexes wisely – Don’t use several indexes when one will do – Understand the “leftmost prefix” rule • Index on (col1, col2, col3) vs. 3 indexes – Don’t index columns until you need to – Verify that indexes are used (difficult) – Use partial indexes on large (text) fields – Index a hash rather than a large value (URL) • MD5 is an excellent choice • It’s even built-in
			Copyright 2003, Jeremy Zawodny