On Tue, Sep 15, 2015 at 04:17:55PM +0100, Brian Hood wrote:
Hi All,
So the new CREATE REPLICA TABLE definition / CREATE TABLE definition i'm not sure what the difference would be ?
CREATE REPLICA TABLE test2 AS (SELECT * FROM test) WITH DATA;
CREATE TABLE test2 AS (select * from test) WITH DATA;
Regards,
Brian Hood Brian
Replica tables shouldn't hold any data, they are meant to describe a set of tables which are all replica's. Using remote tables these could again be on different servers. The idea is to rewrite a query such that the local replica is used. Niels
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: https://www.cwi.nl/people/niels e-mail: Niels.Nes@cwi.nl