What are the SOQL query performance implications of having 100 million records in a custom object, and how should the data model be designed to leverage standard indexes effectively?