Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Performance Tuning Guide > Siebel Analytics > Review Configuration Parameters >

Siebel Analytics Configuration Parameters

---

Consider changing the following parameters in the NQSConfig.ini configuration file for the Siebel Analytics server:

Query Caching
Case-Sensitive Character Comparison
Driving Table per Siebel Analytics example

Query Caching

This was the first technique described in this guide. For the details, see Enable Query Caching.

Case-Sensitive Character Comparison

The parameter that determines whether the Siebel Analytics Server differentiates between lower and upper case characters can impact query performance. When the CASE_SENSITIVE_CHARACTER_COMPARISION parameter in NQSConfig.ini file is set to ON, the server does not retrieve values for the result set that fail to exactly by case. When set to ON, the server can process the query more efficiently.

For instructions that describe how to set this parameter to ON, see Siebel Analytics Installation and Configuration Guide.

Driving Table

Table Joins (driving table, see Siebel Analytics Server Administration Guide)

Repository Configuration

Make sure to select the correct database type in your repository configuration to use the optimal database specific feature for underlying queries.

Bookshelf Home | Contents | Index | Search | PDF