Archives of the TeradataForum

Message Posted: Tue, 02 Sep 2003 @ 23:34:27 GMT

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

Hi Gary:

I understand that you feel that an issue of compression is causing you a problem here. However, what I do not understand is why you would do the CREATE TABLE AS with a derived table (select) and then use the WITH NO DATA.

If you had simply recreated the table with a CREATE TABLE, you would not have caused Teradata to take the time to select some number of rows and the time/work associated with that select and then throw the rows away instead of storing them into the table.

It would seem that a SHOW TABLE to obtain the CREATE TABLE with changes incorporated into it would be much more efficient.

Am I missing something in your approach?

Thanks,

Michael Larkins
Certified Teradata Master

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