The ifx_lo_specset_estbytes() function
The ifx_lo_specset_estbytes() function sets the estimated size of a smart large object.
Syntax
mint ifx_lo_specset_estbytes(LO_spec, estbytes)
ifx_lo_create_spec_t *LO_spec;
ifx_int8_t *estbytes;
- LO_spec
- A pointer to the LO-specification structure in which to save the estimated size.
- estbytes
- A pointer to an ifx_int8_t structure that contains the estimated number of bytes for the smart large object.
Usage
The estbytes value is the estimated final size, in bytes, of the smart large object. This estimate is an optimization hint for the smart-large-object optimizer. For more information about the estimated byte size, see Disk-storage information in the LO-specification structure.
If you do not specify an estbytes value when you create a new smart large object, HCL OneDB™ obtains the value from the inheritance hierarchy of storage characteristics.
Do not change this system value unless you know the estimated size for the smart large object. If you do set the estimated size for a smart large object, do not specify a value much higher than the final size of the smart large object. Otherwise, the database server might allocate unused storage.
Return codes
- 0
- The function was successful.
- -1
- The function was not successful.