Insert into totally slow...

Hello,

I have 2 tables (T_TAB1, T_TEMP). T_TAB1 has approximately 30 columns and 2.6 Mio. records (rows). I put an index on KDNR (NONUNIQUE).

For both tables I created statistics, as well as for the index (calculator symbol in TOAD 7.4).

My SQL-statement is the following:

INSERT INTO T_TEMP (KDNR)
SELECT KDNR
FROM T_TAB1 X
GROUP BY KDNR The explain plan is:

SELECT STATEMENT Hint=CHOOSE (Rows: 874K, Bytes: , Cost: 6800) - SORT GROUP BY NOSORT (Rows: 874K, Bytes: 5M , Cost: 6800) INDEX FULL SCAN (Rows: 2M, Bytes: 15M , Cost: 6800)

The query needs about 1 minute.

Is this a normal execution time? I would assume only a few seconds, but I am a newbie in Oracle.

How can I increase the performance of the query?

Thanks

Florian Received on Mon Nov 21 2005 - 13:40:48 CST