Materialized views can help change the ORDER BY with 0 downtime: * Create a new version of the table with the new ORDER BY. * Create a materialized view that

Materialized views can help change the ORDER BY with 0 downtime: * Create a new version of the table with the new ORDER BY. * Create a materialized view that will insert from the old table to the new table. * Update your application code to query the new table. * Start inserting data into the new table.