469,138 Members | 1,423 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,138 developers. It's quick & easy.

Inserting nothing takes a long time

Hi,
I've a strange problem with a INSERT query. It's taking a long time to
execute. The format is like this :

INSERT INTO table1
SELECT ..
FROM table2

Executing the SELECT .. FROM table2 is taking 30 seconds. The result
is nothing: no records are selected.

When i include the INSERT part it will take 12 hours to complete

INSERT INTO table1
SELECT ..
FROM table2

There's is an index on the table and when i delete it, it gives still
the problem.

Keh?

Greetz,
Hennie
Mar 20 '08 #1
1 1767
Hi!
Is this a real problem? ;-)
Nothing to insert...??

Ok: what is the complete sql?
Remember caching can cause effect when running statement more than
once.

What does "set SHOWPLAN_ALL ON..." tell you?
What do you get when enabling:
SET STATISTICS TIME ON
SET STATISTICS IO ON
/Bjorn
Mar 21 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by KL | last post: by
3 posts views Thread by Joachim Klassen | last post: by
12 posts views Thread by Marcus Kwok | last post: by
6 posts views Thread by fniles | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.