What applications benefit the most in using parallel queries?
Intra-query parallelism, available with Adaptive Server Enterprise 11.5, allows multiple server tasks to share the processing of a single query. This parallel query processing reduces the amount of time required to perform a single large operation, such as loading data into a table or reading a large table. Version 11.5 parallel query processing is designed for Decision Support (DSS) and batch applications that perform scans on large tables. These applications execute long-running queries to scan a large portion of data tables and return a set of summarized rows. Databases also benefit from parallel index creation and parallel bulk copy. Adaptive Server uses multiple execution processes for index creation and supports partition assignments during the bcp process. The use of parallel processing depends on how many pages a query accesses. A server configured for parallel queries only considers a scan of 20 or more data pages for parallel processing. Queries that access 20 or more pages a
