Archives of the TeradataForum
Message Posted: Wed, 25 Feb 2004 @ 21:43:19 GMT
| Subj: | | Re: CREATE TABLE...AS and when SIs are created. |
| |
| From: | | Greg Bourgoin |
On Wed, 25 Feb 2004 12:59:27 -0600, Fred W Pluebell wrote:
| | EXPLAIN says that the index is created first and the MERGE of the data is done afterward. | |
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.
| 
