Data Extraction Facility

The data extraction facility is a group of database options that dramatically improve performance for queries with large result sets.

Like other database options, you can set the data extraction options as temporary or permanent. Ordinarily, these options are set as temporary, for a specific connection.

Advantages of using the extraction options include:

A binary format is supported, which allows loading the output data into the same or a different IQ database.
A SELECT statement with heavy output runs up to four times faster for ASCII output, and up to nine times faster for binary output.

Extract Options
The extract options let you redirect the output of a SELECT statement from the standard interface to go directly to one or more disk files or named pipes.
Enabling Data Extraction Options
Use the data extraction options with care.

Parent topic: Methods for Exporting Data from a Database