All pastes #48836 Raw Edit

Something

public text v1 · immutable
#48836 ·published 2006-04-10 05:00 UTC
rendered paste body
QL-query: 
EXPLAIN SELECT *
FROM db_chars a
LEFT JOIN db_rankings b ON a.char_id = b.char_id
LEFT JOIN db_profiles c ON a.char_id = c.char_id
 [Edit] [Skip Explain SQL] [Create PHP Code]



id 	select_type 	table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
1 	SIMPLE 	a 	ALL 	NULL 	NULL 	NULL 	NULL 	2613907 	 
1 	SIMPLE 	b 	ref 	char_id 	char_id 	4 	wowguru_db.a.char_id 	1 	 
1 	SIMPLE 	c 	eq_ref 	PRIMARY 	PRIMARY 	4 	wowguru_db.a.char_id 	1