Of what type(s) are the join attributes?
How big is the expected join result?
If you don't know,
select count(*), sum(cnt) from (select count(*) as cnt from tmp__pierre2 group by siteniveau1, chapitreniveau1) as x;
select count(*), sum(cnt) from (select count(*) as cnt from ref__at_lm_chapitres group by site, idchapitre1) as x;
might help to give some estimation / idea ...
Best,
Stefan
On December 1, 2014 6:16:11 PM CET, Pierre-Adrien Coustillas
Hello,
With this query : SELECT count(*) FROM tmp__pierre2 SRC INNER JOIN ref__at_lm_chapitres SUB ON SRC.siteniveau1=SUB.site AND SRC.chapitreniveau1=SUB.idchapitre1;
SELECT count(*) FROM tmp__pierre2; +------------+ | L1 | +============+ | 1 061 964 254 |
SELECT count(*) FROM ref__at_lm_chapitres; +---------+ | L1 | +=========+ | 1 331 867 |
after several hours of running the query is still not finished and I stopped
how to find out where the problem?
thanks
Pierre
-- 1G6 52 route de bischwiller 67300 Schiltigheim Société de Services et de Formations en Logiciels Libres http://1g6.biz Tél : 06 64 63 70 35
------------------------------------------------------------------------
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list