So my question here is, I have a table in that gets around 50 million records on a daily basis currently it has more that 5 months data which we are purging using traditional deletes. I think fragmentation might be a problem we might face as we delete more are we and only intend to keep 1 month data for use.
Had I created a new table using CTAS with the 1 month data and drop the original, will it solve the fragmentation problem?
And can using CTAS on any table solve fragmentation?
Note: I'm comparatively new to DB fragmentation concept, please let me know if i'm wrong in asking this question.