Archives of the TeradataForum

Message Posted: Tue, 19 Oct 1999 @ 20:04:32 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Am I missing something here?

I want to insert into an empty 'sample' table 1000 sample rows from two tables. To do this I've run two insert/select statements in parallel using the sample feature.

ie.

     insert into my_sample_table
     sel * from  table_01 sample 1000
     ;insert into my_sample_table
     sel * from table_02 sample 1000
     ;

The explain runs two samples and implies it will insert 2*1000 rows in total, however I only get 1000 rows from table_02.

It does work fine if run serially.

From DBCINFO I'm running

     RELEASE V2R.03.00.02.03
     VERSION 03.00.02.08

thanks

	<Prev	Next>		<<First	<Prev	Next>	Last>>