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 |
Siebel Analytics Performance Tuning Guide Published: 18 April 2003 |