CodingForums.com - View Single Post - Query help with a poorly structured table

shoryuken · 11-25-2012, 04:20 AM

Hi, that command shows:

Code:

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	orderhistory	ref	order_id,lookup order,ticket_id,visible	visible	3	const	2709231	Using where

11-25-2012, 04:20 AM	PM User \| #3
shoryuken New Coder Join Date: May 2012 Posts: 17 Thanks: 2 Thanked 0 Times in 0 Posts	Hi, that command shows: Code: id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE orderhistory ref order_id,lookup order,ticket_id,visible visible 3 const 2709231 Using where