Re: Nested SubQuery Performance/Problem

[Frank Osterberg]

Of course, here it is:

+----+--------------------+-------+-------+---------------+------------+---------+------+---------+--------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+--------------------+-------+-------+---------------+------------+---------+------+---------+--------------------------+
| 1 | PRIMARY | Test | ALL | NULL | NULL | NULL | NULL | 7373970 | Using where |
| 2 | DEPENDENT SUBQUERY | Test | index | NULL | F_Test_Job | 4 | NULL | 7373970 | Using where; Using index |
| 3 | DEPENDENT SUBQUERY | Job | index | NULL | F_Job_Line | 5 | NULL | 6742 | Using index |
+----+--------------------+-------+-------+---------------+------------+---------+------+---------+--------------------------+

Btw, I still have the same problem in 5.0.15

Thanks