Writing Fast Queries
	• EXPLAIN SELECT (continued) – Extra information • Using filesort – An extra pass is required to sort the records – This can be slow at times • Using index – Data will come from the index rather than rows – This can speed things up • Using temporary – MySQL will create a temporary table – It’ll be a disk-based table if it’s too large • Where used – The where clause will be applied to this table
			Copyright 2003, Jeremy Zawodny