|
|
Archives of the TeradataForum
Message Posted: Fri, 17 Aug 2001 @ 12:36:35 GMT
Subj: | | CREATE TABLE AS??? |
|
From: | | Tony Howe |
I have a customer that is doing the following:
create table lid5ueg.anes as
( select
provspec,
place2,
provid,
oempid,
memberno,
dchdate,
billspec
from DB2WHSP.V_RALS_iP_CLAIM
WHERE dchdate BETWEEN '2001-01-01' AND
'2001-02-28' AND CLAIMTYP = 1)
with data
This will run for hours, but if you pull the SELECT out and run by itself, it completes in minutes???
I did the EXPLAIN, but don't understand what's holding it up. The explain says it should complete in minutes as well.
Can anybody enlighten me as to what may be happening here??
Thanks, Tony.
| |