How to apply query hints in TIBCO Data Virtualization at global Server level?
Article ID: KB0071247
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions |
Description
For any important query hints, instead of adding it for each query in TIBCO Data Virtualization (TDV),it would be beneficial if can be added at global Server level. This article provides details on how this can be configured
Issue/Introduction
How to apply query hints in TIBCO Data Virtualization at global Server level?
Environment
All supported Operating Systems
Resolution
1. Launch TDV Studio and navigate to Administration >> Configuration
2. Navigate to Server -> SQL Engine -> Default SQL Options and add the query hints here as a Key Value Pair
For example, if the requirement is to DISABLE_PREAGGREGATION and DISABLE_UNION_PREAGGREGATOR for the queries running in TDV, add them as shown below:
Description of this configuration: This configuration allows default SQL options to be set which take effect if the SQL query has no contradicting option. This option can affect all SQL statements, and should be used with great care. No TDV Server restart is required for the changes to take effect.
2. Navigate to Server -> SQL Engine -> Default SQL Options and add the query hints here as a Key Value Pair
For example, if the requirement is to DISABLE_PREAGGREGATION and DISABLE_UNION_PREAGGREGATOR for the queries running in TDV, add them as shown below:
Description of this configuration: This configuration allows default SQL options to be set which take effect if the SQL query has no contradicting option. This option can affect all SQL statements, and should be used with great care. No TDV Server restart is required for the changes to take effect.
Feedback
Yes
No
Powered by
