We have a custom object which is consuming 80% of org (80 GB) data and we are looking to clean up this data. What is the best way to do this? I can only think of writing a batch job and deleting it but wondering how long does that job run to clean 80 GB of data. Is there any better approach to do this? Appreaciate any help here. 

Currently I can create a report with all the Opportunities which has a partner associated. But I can only report on the fields present on the partner table. But I need to bring in the fields present on the partner account to the report. Is there a way to achieve this?