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