Yes, the system will do a full table rewrite to compute the value and store it. Unfortunately, I believe it is an access exclusive lock during that entire time.
- GENERATED STORED columns and table rewrites? Maciek Sakrejda
- Re: GENERATED STORED columns and table rewrites? Michael Lewis