Question

i am running a query in oracle with CTE. When i execute the query it works fine in select statement but when i use insert statement it takes ample of time to execute.Any help here is the code

INSERT INTO port_weeklydailypricesTest (co_code,start_dtm,end_dtm)
   SELECT * FROM
        (
            WITH CTE(co_code, start_dtm, end_dtm) AS
            (
                SELECT co_code                                                     ,
                CAST(NEXT_DAY(MIN(dlyprice_date), FRIDAY )-6  AS DATE)   start_dtm ,
                CAST(NEXT_DAY(MIN(dlyprice_date), FRIDAY ) AS DATE)      end_dtm
                FROM   feed_dlyprice
                GROUP BY co_code
                UNION ALL
                SELECT  co_code     ,
                CAST(TO_CHAR(end_dtm + INTERVAL  1  DAY, DD-MON-YYYY ) AS DATE),
                CAST(TO_CHAR(end_dtm + INTERVAL  7  DAY, DD-MON-YYYY ) AS DATE)
                FROM    CTE
                WHERE   CAST(end_dtm AS DATE) <= TO_CHAR(TO_DATE(SYSDATE+1, DD-MON-YYYY ))
             )
            SELECT co_code,start_dtm,end_dtm 
            FROM CTE
        );

Answer 1

如你所说,如果选任考试委员会本身的工作表现令人满意,则问题必须归于专家审评组。

某些事情可能会导致插入速度缓慢:

The most likely is the presence of a trigger on the target table which executes something very expensive.
Another possibility is that the insert is waiting on a locked resource (say some other process has an exclusive table level lock on the target table, or some other shared resource such as a code control table).
it could be a storage allocation issue, chaining or row migration, too many indexes or lots of derived columns.
perhaps it is down to hardware - underpowered network, dodgy interconnects, a bad disk.

这绝不是详尽的。这些项目是你能够调查和解决的申请问题。名单上的各位越多越好,你就越需要现场的德国统计局的援助。

友情链接