Loading of data into a table

You can use the CREATE RAW TABLE statement to create a RAW table or use the ALTER TABLE statement to change a STANDARD table to RAW before loading the table. After you load the table, run UPDATE STATISTICS on it.

HCL Informix® creates STANDARD tables that use logging by default. Data warehousing applications can have huge tables that take a long time to load. Nonlogging tables are faster to load than logging tables.

For more information about how to improve the performance of loading very large tables, see your HCL Informix Performance Guide. For more information about using ALTER TABLE to change a table from logging to nonlogging, see the IBM Informix Guide to SQL: Syntax.

Copyright© 2018 HCL Technologies Limited