Thanks a lot Martin for your input. I will experiment this idea and I'll come back to share the results I get iwth MonetDB. Best regards, Franck Le 04/07/2013 20:12, Martin Kersten a écrit :
Use vertical decomposition schema design.
create table large( i integer, j integer)
can be represented by create table largeI( surrogate integer, i integer ); create table largeJ( surrogate integer, j integer );
create view large as select * from largeI join largeJ union select * from largeI left outerjoin largeJ union select * from largeI right outerjoin largeJ
On 7/4/13 8:08 PM, Franck Routier wrote:
Hi Martin,
Le 04/07/2013 19:04, Martin Kersten a écrit :
You might consider using a large number of columns using your own key, glued together with a view.
What do you mean by 'using your own key' ?
Best regards, Franck
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list