What is the best logic of implementing purge. We have a application having millions of records and we want to purge on the data basis. Please explain how purge works in DB. As per my understanding is when we purge it drop all indexes, re-org the table and do the index creation again. What all process goes in background and what is best performing solution.