The Indexes Pivot Table
Traditional database systems rely on indexes to quickly locate specific rows in a database table that have fields matching a specific condition. However, it is not practical to create native database indexes for the flex columns of the Data table because Force.com is likely using a single flex column to store the data of many fields that have varying structured datatypes. Instead, Force.com manages an index of the Data table by synchronously copying field data marked for indexing to an appropriate column in a pivot table called Indexes, as depicted in a simplified ER diagram (Figure 7).
Figure 7. Force.com uses a pivot table to index data stored in flex columns.
The Indexes table contains strongly typed, indexed columns ...
Get The Force.com Multitenant Architecture: Understanding the Design of Salesforce.com’s Internet Application Development Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
