The unfortunate part for everyone is the SELECT operation with qualifier must walk through every record in the DB (of which there are hundreds of millions in this case) to determine which ones are valid. That unfortunately takes time.
I hope this script will help those who need to reduce the size now and are unable to wait for PMS to reduce during each nightly tasks.
