Summary
In this chapter, we have learned that understanding not just the volume of records but also how the data within them is dispersed can affect the need for indexes to ensure that queries perform without having to resort to expensive table scans or, in the case of Apex Triggers, runtime exceptions. Ensuring that you and your customers understand the best way to apply indexes is critical to both interactive and batch performance.
Big Objects provide a means to access the benefits of NoSQL databases to manage billions of records using specialized Salesforce APIs and Apex programming patterns using Platform Events to ingest data. Big Objects are a manifestation of BASE data access principles, which are better designed for large-scale data access compared to Custom Objects and Standard Objects following ACID principles. The latter are more suitable for transaction data volumes, including the ability to manage larger, more complex transactions.
Asynchronous execution contexts...