KI_SET_EXTENT
| Argument | Enumeration | Purpose |
|---|---|---|
| handle | Handle | |
| percent | Percentage of original table size for the extent | |
| mode | Mode flags | |
| status | KDB_ERROR_ENUM | Return status |
KI_SET_EXTENT
The argument percent is the percentage of current maximum rows the table should automatically be extended by when either the index or data fills. Set this to zero to disable autoextending. The mode is a bit field.
| Bit | Purpose |
|---|---|
| 0x01 | auto-reindex ON if set (KDB6 only) |
| 0x02 | auto-extension ON if set |
Compatibility
This has no effect on Oracle tables. The size of extents should be configured when the tablespaces are created.
KDB7 tables will extend automatically up to the available space in the filesystem. If the percentage is not set with an EXTEND clause in CREATE TABLE the default is 50%.
KDB6 tables can extend automatically for a limited number of extents. KDB5 and earlier cannot do this on their own but KI_GROW and KI_EXTEND and manually extend a table. KDB6 tables can recover space and postpone running out of space by reindexing on the fly. This is not enabled by default.
When a table is extended or re-indexed automatically a warning entry is raised in the error log (see WRITE LOG for more about error logs).