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

CEO of Rittman Analytics, host of the Drill to Detail Podcast, ex-product manager and twice company founder.

CEO of Rittman Analytics, host of the Drill to Detail Podcast, ex-product manager and twice company founder.