Archives of the TeradataForum
Message Posted: Fri, 17 Aug 2001 @ 12:36:35 GMT
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??
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|