[[{“value”:”I’ve written what I thought was a good way to purge 1.6 billion records down to 600 million. The issue is rebuilding logicals over the physical. If we write the records to a new file with the logical files in place after 309 million records or so it takes multiple seconds to add 1 record. If we build the logical files later it still takes hours. Anyone have any suggestions?? We finally decided to purge in place and reuse deleted.
submitted by /u/Pleasant_Long4360[link][comments]”}]] Read More