Creating and Loading Tables Fragmented Across Coservers

After you have created dbslices and dbspaces, you can create tables fragmented across multiple coservers. For VLDBs that are fragmented across many coservers, system-defined hash on the join column is often a good first choice for a fragmentation scheme.

For more details on fragmentation strategies, refer to your IBM Informix: Performance Guide. For details on how to use the CREATE TABLE statement to fragment tables, refer to the IBM Informix: Guide to SQL Syntax.

Extended Parallel Server provides external tables that allow you to load multiple table fragments in parallel across multiple coservers. For more details on how to use these tables, refer to the chapter on loading with external tables in the IBM Informix: Administrator's Reference.