flights & materialized views tables order first_time_seen ASC, but we always query DESC
Changing the default clustering order is... tricky. We cannot change the existing table. It's unclear what the performance penalty we're paying is.
Changing the default clustering order is... tricky. We cannot change the existing table. It's unclear what the performance penalty we're paying is.