Z0ZUTKii

1dodmoshe@pond:~/safe/DB/ex5% cat create.sql
2drop table if exists TABLE1;
3drop table if exists TABLE2;
4
5CREATE TABLE TABLE1 (
6aid INTEGER PRIMARY KEY,
7descr VARCHAR(50) NOT NULL
8);
9
10CREATE TABLE TABLE2 (
11bid INTEGER PRIMARY KEY,
12descr VARCHAR(50) NOT NULL
13);
14
15INSERT INTO TABLE1  SELECT generate_series(1,100000) AS aid, md5(random()::text) AS descr;
16
17INSERT INTO TABLE2  SELECT generate_series(1,100000) AS bid, md5(random()::text) AS descr;
18
19/*SELECT * FROM TABLE1;
20
21SELECT * FROM TABLE2;*/
22
23EXPLAIN SELECT * FROM TABLE1, TABLE2;
24
25CREATE INDEX INDEXonTABLES ON TABLE1 (descr);
26
27EXPLAIN SELECT * FROM TABLE1, TABLE2;
28
29drop table if exists TABLE1;
30drop table if exists TABLE2;