Introduction to NonStop SQL/MP

Summary

1–18 113425 Tandem Computers Incorporated

Parallel Sorting Utility If a query requires that the data be sorted, NonStop SQL/MP determines whether to

sort the data in the virtual memory allocated to the user or to call an external sort

routine. If you need to sort more than 32,767 rows, NonStop SQL/MP sends your data

to the FastSort utility. FastSort can perform the sort in parallel so that multiple

processors can work on the sort concurrently. Also, if a sort that is started in the user

process space runs out of memory, the partial results are gracefully migrated to the

FastSort utility, which completes the task.

Summary NonStop SQL/MP is ideally suited for database applications requiring easy access to

the data, high performance, high availability, and the ability to scale up the database

as the business grows. Conforming to industry-standard programming tools and

protocols and accessible from popular PC software tools, NonStop SQL/MP combines

open access with the parallel, distributed processing environment made possible by

Tandem’s multiprocessor architecture.