26 Mar
2008
26 Mar
'08
1:28 a.m.
Hi Niels,
INSERT INTO table_name (...) ORDER BY X,Y
OK, thank you for your answer. Two more questions: 1.) Is it also ok to insert the triples in sorted order one after the other, instead of copying combined with ORDER BY? Is there any possibility to see whether MonetDB /really/ recognizes that tuples are ordered? 2.) How can I detect whether MonetDB chooses merge joins when joining on ordered columns. I used EXPLAIN and investigated the QEP (though I must confess that I don't really understand what's going on), but there were only "algebra.join" operations, whatever this means... Michael