Using a row order policy has significantly improved query time and compression factor for my non-materialized views. I'm considering applying the same policy to materialized views, but the ADX documentation doesn't indicate if this is supported for materialized views.
Can someone confirm that ADX does not support row order policy for materialized views? And what the logic behind not supporting it is?
it is technically supported (though as you mentioned, not currently documented).
you can run, for example:
.alter materialized-view MyMaterializedView policy roworder (MyColumn asc)