We are experiencing performance issues with a custom object called first_invoices__c. The object has approximately 190,000 records however we are unable to query the object. From the back end we attempt to execute the following and we hit a 2 minute time out.

select id from first_invoices__c
limit 1

We also tried the following based on a recommendation with no improvement

select id from first_invoices__c
order by id
limit 1

We are also experience issues from the front end ...... at whatever color here...

NOTE: As part of an integration project, this object is completely purged and reloaded on a nightly basis.