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