Archives of the TeradataForum
Message Posted: Wed, 25 Feb 2004 @ 21:43:19 GMT
On Wed, 25 Feb 2004 12:59:27 -0600, Fred W Pluebell wrote:
Good point. Should have gone with the explain first, and, practical experience says you are right as well. I tested this on a smaller table. The with nothing else specified, the CREATE TABLE as OLDTABLE with/with no data does the follwing (contrary to another post):
- It does keep the primary index intact, if not otherwise specified.
- It does create secondary indexes first (if not otherwise specified) and then loads the data.
Thanks for the responses everyone.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|