Partition or Join Pruning Optimization
Sometimes, for partitioned data, you want to run a query against a specific partition. This behavior is often referred to as join pruning. TDV has been set to perform this for you automatically. If you want to manipulate or confirm the settings, you can use the TDV configuration parameters that are accessed through Studio.
Requirements
• Null values are not allowed in the tables for join pruning consideration.
To review the join pruning optimization
1. In Studio, navigate to Administration > Configuration.
2. Expand Server > SQL Engine > Optimizations.
3. Locate the Disable Join Pruner configuration parameter.
4. Validate or change the value.
5. Select Apply or OK.
The change in the parameter takes effect immediately. All queries that begin processing after the configuration parameter change are analyzed to see if they can take advantage of the optimization. There is no need to restart the server.