Comment Comment by vadman97 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. parent vadman97 2 years ago
* 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.