[Table Rotation] When adding a field to the base table, to set the default value, the system unions all shards to get the sys ids unnecessarily causing slowdown - Known Error

[Table Rotation] When adding a field to the base table, to set the default value, the system unions all shards to get the sys ids unnecessarily causing slowdown Description Slow upgrade process whilst performing an alter on syslog_transaction. When adding a field to the base table, to set the default value, the system unions all shards to get the sys ids unnecessarily causing a slowdown.

Steps to Reproduce

Upgrade from Paris to Quebec on Oracle where syslog_transaction has two new fields that are deferred. Notice that there are many select statements unioning all syslog_transaction shards.

Workaround This problem is currently under review. You can contact ServiceNow Technical Support or subscribe to this Known Error article by clicking the Subscribe button at the top right of this article to be notified when more information becomes available.