-- usefull temporary tables


create global temporary table tempmemf(idf integer, ids integer);

-- temporary table for storing memf


create global temporary table tempevaluation(idq integer, idf integer, dimu number(5,3));

-- temporary table for storing evaluations


create global temporary table tempqueries(idq integer, ids integer, nr_repetition integer);

-- temporary table for storing queries