1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
DROP TABLE one;
DROP TABLE two;
CREATE TABLE one (
id INT PRIMARY KEY AUTO_INCREMENT,
a INT,
b INT );
INSERT INTO one (a) SELECT n*10 FROM serie LIMIT 2000;
CREATE TABLE two (
a int,
b int
);
INSERT INTO two (a,b) SELECT n*10,n FROM serie LIMIT 1000;
-- CREATE INDEX two_a ON two(a);
UPDATE one,two SET one.b=two.b WHERE one.a=two.a;
-- sans le CREATE INDEX
Query OK, 1000 rows affected (2.35 sec)
Rows matched: 1000 Changed: 1000 Warnings: 0
-- avec le CREATE INDEX
Query OK, 1000 rows affected (0.02 sec)
Rows matched: 1000 Changed: 1000 Warnings: 0 |
