Archives of the TeradataForum

Message Posted: Wed, 25 Feb 2004 @ 18:41:15 GMT

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

I'm wondering if anyone can tell me when secondary indexes are materialized on the new table when using the CREATE TABLE...AS syntax. Are the indexes created with the table, then the data is loaded (bad)? Or, is the data loaded and THEN the indexes are created (good)? For smaller tables this may not be an issue but I'm getting ready to create/load a 70+million row table with 3 SIs. It would make the difference of 15-20 minutes versus many hours.

Though just doing the old fashioned create/load/create indexes would have been faster than actually typing this message, I still would like the benefit of knowing for myself (and others) what the answer is for future reference.

Have a good one,

Greg

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