You can control the resources that the database uses to perform decision-support queries in parallel. You need to balance the requirements of decision-support queries against those of online transaction processing (OLTP) queries. The resources that you need to consider include shared memory, threads, temporary table space, and scan bandwidth. For information on parallel database query (PDQ) and how fragmentation affects the performance of PDQ, see your IBM Informix Dynamic Server Performance Guide. For information on the configuration parameters, see Decision-Support Parameters.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]