質問編集履歴
1
EXPLAINの結果を追記しました
test
CHANGED
File without changes
|
test
CHANGED
@@ -103,3 +103,31 @@
|
|
103
103
|
50 rows in set (4 min 37.47 sec)
|
104
104
|
|
105
105
|
```
|
106
|
+
|
107
|
+
|
108
|
+
|
109
|
+
### 追記
|
110
|
+
|
111
|
+
EXPLAINの結果です。
|
112
|
+
|
113
|
+
|
114
|
+
|
115
|
+
```
|
116
|
+
|
117
|
+
+----+-------------+------------+------+---------------+------+---------+------+-----------+----------------------------------------------------+
|
118
|
+
|
119
|
+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|
120
|
+
|
121
|
+
+----+-------------+------------+------+---------------+------+---------+------+-----------+----------------------------------------------------+
|
122
|
+
|
123
|
+
| 1 | PRIMARY | <derived2> | ALL | NULL | NULL | NULL | NULL | 120000000 | Using temporary; Using filesort |
|
124
|
+
|
125
|
+
| 1 | PRIMARY | <derived3> | ALL | NULL | NULL | NULL | NULL | 120000000 | Using where; Using join buffer (Block Nested Loop) |
|
126
|
+
|
127
|
+
| 3 | DERIVED | table | ALL | NULL | NULL | NULL | NULL | 120000000 | Using temporary; Using filesort |
|
128
|
+
|
129
|
+
| 2 | DERIVED | table | ALL | NULL | NULL | NULL | NULL | 120000000 | Using temporary; Using filesort |
|
130
|
+
|
131
|
+
+----+-------------+------------+------+---------------+------+---------+------+-----------+----------------------------------------------------+
|
132
|
+
|
133
|
+
```
|