Optimize Query Performance
Optimizing the database consists of optimizing for compression and tuning for queries. (See Creating a Database Design.)
To optimize the database, use the Database Designer to create and deploy a design for optimizing the database. See the Tutorial in Getting Started for an example of using the Database Designer to create a Comprehensive Design.
After you have run the Database Designer, use the techniques described in Query Optimization in Analyzing Data to improve the performance of certain types of queries.
Note: The database response time depends on factors such as type and size of the application query, database design, data size and data types stored, available computational power, and network bandwidth. Adding nodes to a database cluster does not necessarily improve the system response time for every query, especially if the response time is already short, e.g., less then 10 seconds, or the response time is not hardware bound.