What does the explain look like for this query?
Like this:
mysql> explain (SELECT DISTINCT g.id
-> FROM Broadcast b, Genre g
-> WHERE g.id IN (0)
->
-> ) UNION (
-> SELECT DISTINCT b.id
-> FROM Broadcast b, Genre g
-> WHERE g.id IN (0)
->
-> ) LIMIT 1 \G
*************************** 1. row ***************************
id: 1
select_type: PRIMARY
table: b
type: index
possible_keys: NULL
key: PRIMARY
key_len: 4
ref: NULL
rows: 12428
Extra: Using index; Using temporary
*************************** 2. row ***************************
id: 1
select_type: PRIMARY
table: g
type: range
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: NULL
rows: 1
Extra: Using where; Using index
*************************** 3. row ***************************
id: 2
select_type: UNION
table: b
type: index
possible_keys: NULL
key: PRIMARY
key_len: 4
ref: NULL
rows: 12428
Extra: Using index; Using temporary
*************************** 4. row ***************************
id: 2
select_type: UNION
table: g
type: range
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: NULL
rows: 1
Extra: Using where; Using index; Distinct
4 rows in set (0.00 sec)Jim -- James Fryer / [EMAIL PROTECTED] / [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
