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