Hi:
I have a situation where I will be inserting thousands of records into a table but leaving 2 of it’s columns null. Later on, I will be updating most of those records and putting real values in place of those 2 nulls. As for the ones that do not get updated, I want to leave them null. My concern has to do with record fragmentation at the time of update because there’s no room to “expand” them to accept the non-null data. (BTW, the columns are floating point).
Is there a way to initially insert nulls, but reserve space for the future update (and avoid record fragmentation)?
Is my record fragmentation concern unfounded?
Thanks in Advance !