Quick Start for Small-Database User

This section is for users who have a small database with each table residing on only one disk and using only one CPU virtual processor.

To achieve acceptable initial performance on a small database

Generate statistics of your tables and indexes to provide information to the query optimizer to enable it to choose query plans with the lowest estimated cost.
These statistics are a minimum starting point to obtain good performance for individual queries. For guidelines, see Updating Statistics. To see the query plan that the optimizer chooses for each query, see Displaying the Query Plan.
If you want a query to execute in parallel execution, you must turn on the Parallel Database Query (PDQ) feature.
Without table fragmentation across multiple disks, parallel scans do not occur. With only one CPU virtual processor, parallel joins or parallel sorts do not occur. However, PDQ priority can obtain more memory to perform the sort. For more information, see Parallel Database Query.
If you want to mix online transaction processing (OLTP) and decision-support system (DSS) query applications, you can control the amount of resources a long-running query can obtain so that your OLTP transactions are not affected.
For information on how to control PDQ resources, see Allocating Resources for Parallel Database Queries.
Monitor sessions and drill down into various details to improve the performance of individual queries.
For information on the various tools and session details to monitor, see Monitoring Memory Usage for Each Session and Monitoring Sessions and Threads.