Archives of the TeradataForum
Message Posted: Wed, 25 Feb 2004 @ 18:41:15 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|