I've discovered that the partitions used on a particular table are hurting query performance and would like to remove the partitions from the table. Is there an easy way to do this? The table in question has 64 partitions. Based on some initial investigation, I've come up with the following options. Is there a better way?
Thoughts?
Personally I think a variant on option 2 sounds like the best approach.
(*) A non-partitioned table will probably require different indexes from the partitioned one. If you are particularly attached to the index names you can use ALTER INDEX ... RENAME TO ...
syntax after step 6.
The advantage of this approach is that it minimises your downtime (basically steps 3, 4 and 5).