When possible, Sybase IQ uses multithreading to improve load performance.
Fixed-width loads and full-width, row-delimited loads (where size and limit=0) will run fully multithreaded provided enough resources—memory and/or threads—are available. If there are not enough resources, the load runs on a single thread, and this message appears in the .iqmsg file:
The insert to the table will be single threaded.
Variable-width loads without row-delimited data, and partial-width variable-width loads, will run only partially multithreaded at best, provided there are enough resources to do so. For loads that are partially multithreaded, the following message appears in the .iqmsg file:
Portions of the insert/load will be multithreaded.
