Re: update of null column vs. update of non-null column

Hi,
In one hand, update null column may lead to raw migration (if after update no free space in block for new raw). After that, when you select, this row will be fetch more slower.
In other hand, same case may be if you update non-null column and new value larger then old value and no free space in block. But this case meet seldom.

Best Regards.
Yaroslav

"Drazen Kozic" <dkozic_at_eunet.yu> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:98l4vk$gh2$1_at_news.EUnet.yu...
> Hi,
>
> Is there any performance impact in update of null column compared to
 update
> of non-null column.
> Null column is positioned in the middle of the record.
> I will appreciated any suggestion.
>
> (Oracle 8.1.5 Enterprise Edition)
>
> Thanks in advance
>
> Drazen
>
>
>
>
Received on Wed Mar 14 2001 - 12:19:27 CET