The Clobs Table
Force.com supports the declaration of fields as character large objects (CLOBs) to permit the storage of long text fields up to 32,000 characters. For each row in the Data table that has a CLOB, Force.com stores the CLOB out-of-line in a pivot table called Clobs, which the system can join with corresponding rows in the Data table as necessary.
Note: Force.com also stores CLOBs in indexed form outside the database for fast text searches. See Section 9 for more information about Force.com’s text search engine.
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.
