Hmm strange.. my primary key (col1) no longer has an ascending order. Sure i can do an order by, but doesnt this affect the index on the primary key? Or is the pointer still located before the 9 in the col1 column?
I can imagine this giving a huge mess when you have 200000 or so rows.. and every now and then you update a row and you are therefor forced doing a complete table scan.
Cant remember seeing an explination for this in the documentation (and wasnt able to find an anwser using google) but on the otherhand, im dutch so i could have just missed it.