By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,854 Members | 833 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,854 IT Pros & Developers. It's quick & easy.

Inserting nothing takes a long time

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.