Hi Filipe
Thanks for the link and the comments!
Do you know what specific operations on a clustered table cause table sorting to be degraded over time? Do regular table inserts cause this problem or is it only updates, deletes and merge DML commands? If inserts don’t cause table sorting to become degraded, does BigQuery re-sort the table’s data after the insert completes, if so do columns end-up migrating between storage blocks when this re-sorting happens?
Mark