Sort memory

The amount of virtual shared memory that the database server allocates for a sort depends on the number of rows to be sorted and the size of the row, along with other factors.

The following database operations can use large amounts of the virtual portion of shared memory to sort data:

• Decision-support queries that involve joins, groups, aggregates and sort operations
• Index builds
• UPDATE STATISTICS statement in SQL

For information about parallel sorts, see your HCL Informix® Performance Guide.