Re: Subqueries in NDB cluster

[Ruchith Gunaratne]

Hi ,

Following is a expain resposne for a sub query in my system.

mysql> EXPLAIN select * from LAP_RULES where ( RC_RULE_CODE='MULTIPLE' ) and RLS_RULE_ID in ( select RLS_PARENT_RULE_ID from LAP_RULES where ( RLS_STATUS='EXECUTED' or RLS_STATUS='PENDING_EXECUTION' ) );
+----+--------------------+-----------+------+---------------+---------------+---------+-------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+--------------------+-----------+------+---------------+---------------+---------+-------+------+-------------+
| 1 | PRIMARY | LAP_RULES | ref | RULE_CODE_IND | RULE_CODE_IND | 12 | const | 10 | Using where |
| 2 | DEPENDENT SUBQUERY | LAP_RULES | ALL | NULL | NULL | NULL | NULL | 123 | Using where |
+----+--------------------+-----------+------+---------------+---------------+---------+-------+------+-------------+
2 rows in set (0.02 sec)

thanks,