The number of records on the Customer Maintenance - Invoices tab is based on the "number of days to retain paid invoices" setting in A/R Options.  This data is stored in the AR_OpenInvoice table.  I would not use SQL to purge data from this table; however, you may want to consider lowering the current number of days to retain paid invoices setting.  Of course, the data is purged automatically when you run A/R Period End Processing, based on the number of days setting.

Less records in the AR_OpenInvoice table could potentially increase the speed of load time on the Transactions tab.  Best way to find out is to make a test company and try your changes in that company first.

The number of records on the Customer Maintenance - Invoices tab is based on the "number of days to retain paid invoices" setting in A/R Options.  This data is stored in the AR_OpenInvoice table.  I would not use SQL to purge data from this table; however, you may want to consider lowering the current number of days to retain paid invoices setting.  Of course, the data is purged automatically when you run A/R Period End Processing, based on the number of days setting.

Less records in the AR_OpenInvoice table could potentially increase the speed of load time on the Transactions tab.  Best way to find out is to make a test company and try your changes in that company first.

We have invoices showing from 11/4/2013, and our "days to retain paid invoices" is set to 750. 

The settings is based on the payment date.  For example, based on your "750 days" setting, invoices paid on or after 5/1/2017 will be in the AR_OpenInvoice table.  Are you running A/R Period End Processing every month?  If you're not running period end processing, the paid invoices will not purge from the table after 750 days from the payment date.