|
|
Archives of the TeradataForum
Message Posted: Fri, 17 Aug 2001 @ 12:50:38 GMT
Subj: | | Re: CREATE TABLE AS??? |
|
From: | | Mike Vanole |
This will run in seconds:
| create table WITT.test2 as (select columnname, tablename, databasename, columntype from dbc.columns) with data primary index
(columnname, tablename, databasename); | |
While this runs in 45 min:
| create table WITT.test1 as (select columnname, tablename, databasename,
columntype from dbc.columns) with data; | |
Try specifing a primary index.
| |