質問編集履歴

1

EXPLAINの結果を追記しました

2018/10/23 06:40

投稿

hang
hang

スコア12

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
+ ```