FastSort Manual

Introduction to FastSort
FastSort Manual—429834-003
1-11
Products That Use FastSort
When you use the SQLCI CREATE INDEX statement, SQL uses FastSort to load data
into the target table. When you use the SQLCI LOAD utility to load data into a key-
sequenced table and you do not specify the SORTED option, SQL uses FastSort to
sort the data.
When you specify PARALLEL EXECUTION ON for either of these statements, the
SQL/MP catalog manager (SQLCAT) process starts a RECGEN process for each
partition of the base table and a SORTPROG process for each partition of the index.
The RECGEN processes read the rows of the base table. SORTPROG processes sort
the generated rows and write them to the partitions of the index.
For more information about the CREATE INDEX or LOAD statements, see Section 8,
Sorting From NonStop SQL/MP.