View Single Post
Old 01-20-2013, 04:09 AM   PM User | #3
Mayhem30
New Coder

 
Join Date: Jan 2010
Posts: 63
Thanks: 2
Thanked 5 Times in 4 Posts
Mayhem30 is an unknown quantity at this point
Code:
+----+-------------+--------------------+-------+---------------+------+---------+------------------------------+------+------------------------------+
| id | select_type | table              | type  | possible_keys | key  | key_len | ref                          | rows | Extra                        |
+----+-------------+--------------------+-------+---------------+------+---------+------------------------------+------+------------------------------+
|  1 | SIMPLE      | pac2_notifications | range | what          | what | 919     | NULL                         |    2 | Using where; Using temporary |
|  1 | SIMPLE      | pac2_titles        | ref   | uri           | uri  | 767     | test.pac2_notifications.what |    1 |                              |
+----+-------------+--------------------+-------+---------------+------+---------+------------------------------+------+------------------------------+
2 rows in set (0.00 sec)

I know the when "using temporary" shows up - it's not good ...

Any help would be appreciated!
Mayhem30 is offline   Reply With Quote