One doubt

In Informix IDS 7.31 for Windows, the PSORT_NPROCS environment variable not exists or not works? Thanks in advance

7.31 does support PSORT_NPROCS From http://www.iiug.org/resources/faq/ifaq08.htm 8.29 How can I speed up sorts and index builds? On 11th May 1998 kagel@bloomberg.com (Art S. Kagel) wrote:- You have stumbled on a little known fact. Sorting is faster to filesystem space than to temp table space. And since you do not care about the safety of those sort-work files that's OK. Even better still, for large sorts like index builds and UPDATE STATISTICS, set the environment variable PSORT_DBTEMP to as many different filesystems as possible (at least 3, keeping in mind that the smallest will limit the size of the sort that is possible). Also, contrary to the documentation, setting PSORT_NPROCS to a value between 20 and 40 will also speed the sorting as long as you can afford to allocate so many resources to that one task. You might see the time drop to 15 or 20 minutes.