|
|
|
|
||||||
![]() |
|
|
LinkBack | Outils de la discussion |
|
|
#1 |
|
Messages: n/a
Hébergeur: |
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 |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
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 |
|
![]() |
| Outils de la discussion | |
|
|