
[MonetDB] create table: time = 0.011998653411865234 s 

[MonetDB] load data : time = 5.0567710399627686 s 

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "AIRLINE" = 'AA';
 time = 0.09319911003112794 s
size=725984

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights;
 time = 0.3854343414306641 s
size=5819079

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 5;
 time = 0.5878424167633056 s
size=4862950

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 10;
 time = 0.5355197429656983 s
size=3906644

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 15;
 time = 0.413877534866333 s
size=2948366

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 20;
 time = 0.2687976837158203 s
size=1980764

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 25;
 time = 0.1548001289367676 s
size=1032732

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 30;
 time = 0.0436246395111084 s
size=103812

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 5 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000; 
 time = 0.03333969116210937 s
size=0

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 10 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000; 
 time = 0.03139915466308594 s
size=0

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 15 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000; 
 time = 0.030199241638183594 s
size=0

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 20 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000; 
 time = 0.031200647354125977 s
size=0

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 25 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000; 
 time = 0.029999637603759767 s
size=0

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 30 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">12000; 
 time = 0.03231091499328613 s
size=0

[MonetDB] requete (moyenne de 5) : CREATE TABLE flights10 AS SELECT * FROM FLIGHTS WHERE "DAY" > 10;
 time = 0.8868450164794922 s
size=-1

[MonetDB] requete (moyenne de 5) : DELETE FROM flights WHERE "DAY" > 10;
 time = 0.04511580467224121 s
size=3906644

[MonetDB] requete (moyenne de 5) : INSERT INTO flights SELECT * FROM flights10;
 time = 2.8564552783966066 s
size=3906644

[MonetDB] requete (moyenne de 5) : DROP TABLE flights10;
 time = 0.023737668991088867 s
size=-1

[MonetDB] requete (moyenne de 5) : CREATE TABLE flights2 AS SELECT * FROM FLIGHTS;
 time = 4.412073850631714 s
size=-1

[MonetDB] requete (moyenne de 5) : UPDATE flights2 SET "WEATHER_DELAY" = -1 WHERE "WEATHER_DELAY" IS NULL;
 time = 0.6633326053619385 s
size=4755640

[MonetDB] requete (moyenne de 5) : DROP TABLE flights2;
 time = 0.004267215728759766 s
size=-1

