On Tue, Jan 08, 2008 at 08:23:40AM -0800, sateesh wrote:

Hi All,

If i create two logical tables which has the same column then when MonetDB actually creates the Physical Tables does it create two tables for this Column..

For Ex: I created these two Tables at the Logical Level..

TAB_1 col_1 varchar(100), col_2 int TAB_2 col_3 varchar(256), col_2 int

Now I home MonetDB will create these physical tables..

For TAB_1

PHYSICAL_TAB_1 PHYSICAL_TAB_2 OID , COL_1 OID , COL_2

How abt for TAB_2

Does it create PHYSICAL_TAB_3 PHYSICAL_TAB_4 OID , COL_3 OID , COL_2

It needs this physical (4) too. Else there is no way to store the values of tab_2.col_2. The logical tables are different. If you would like some table to reuse columns of an other table, you should create a view. Niels

or Just

PHYSICAL_TAB_3 OID , COL_3

Thanks Sateesh

-- View this message in context: http://www.nabble.com/Info-reg-the-Physical-Tables..-tp14692698p14692698.htm... Sent from the monetdb-users mailing list archive at Nabble.com.

------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl