>Tested this and you're right. If you index on "f1" in Mike's code and then run it, the record gets place at the physical end of file, or, basically where the index would show it. That's pretty unusual behavior.
Yep, it's exactly what I did. Really strange. Looks like we can insert in the middle of the table only if the table doesn't have indexes at all.
Should test it more throughly to confirm this assumption, though.
>
>
>>Seems to work only if there are no indexes at all.
>>Try add index and set order to before inserting...
If it's not broken, fix it until it is.
My Blog