1. New Features in Ingres 10.2 : DBMS Server Enhancements : Inline BLOBs
 
Share this page                  
Inline BLOBs
You can specify the number of bytes to allocate for inline space for a blob column. If the blob requires more space than is allocated, it is stored in an extended table. Inline blobs can improve the performance of queries that access blob data because, in some cases, no additional I/O is required to fetch, insert, or update the data.
Configuration parameters can be used to set the default size for the inline space, depending on the data type of the large object.
For more information, see the Database Administrator Guide and SQL Reference Guide.