Too slow to make an insert... select
558369Nov 29 2007 — edited Dec 5 2007Hi, I want to do an insert...select... in a table and I'm looking that the time is too long. The query has to insert only 15000 records, so I think they aren't many records.
If I execute only the select it takes me only 6 secs, but the insert is about 30 min.
I don't know why it takes so long.
It can be a problem with the temp tablespace?. It has a size of 2500 Mb (I think an enough size for 15000 records)?
Thank you very much.