I call for a vote of no confidence...
Running the statement
select count(*) from BagLocations
returned the value
19 014 584
.
Then I started the following query:
insert into BagLocations_JuganTemp
select * from BagLocations
Then, while that was running (it ultimately took 6:33), I ran
select count(*) from BagLocations
which returned about
3 000 000
.
Then, once the long-running query completed, I ran
select count(*) from BagLocations
which returned
19 014 584
again, as did
select count(*) from BagLocations_JuganTemp
.
Ju-ju bad. Verry badd.
Posted on Friday, September 08, 2006
by
Unknown
0 comments:
Post a Comment