SE_xmlcolumninfo_set_load_mode
Sets an XML column into or out of load mode.
Usage syntax
LONG SE_ xmlcolumninfo_set_load_mode(const SE_XMLCOLUMNINFO xmlcolumn, BOOL is_in_load_mode);
Parameters
|
xmlcolumn |
The xml column name. |
|
is_in_load_mode |
Set to TRUE to put a column into load mode, or FALSE to put it out of load mode. False is the default if this function is never called. |
Description
When in load mode, the column’s indexes are dropped, including the full-text index. An XML column in load mode cannot be queried. If you are loading a large amount of data, such as when first populating a table, you may want to put the xml columns in load mode first, and then toggle it back out of load mode after the data load. When inserting initial data, it may be more efficient to create the indexes after the load instead of having the database maintain the indexes during the data load.
Returns