Can you try using cluster by:    create table new_table as select row_number() over () as ID, * from old_table cluster by ID; ... View more