You can translate the question and the replies:

cost-based optimization

What are the minimal conditions needed for the cost-based optimization of an execution plan?
21-02-2023 15:53:38 -0500

1 Answer

Hi, The minimal conditions needed for the Cost-Based Optimization of an execution plan are for the execution engine to: 1. Apply the static optimizations 2. Select the best execution plan based on the estimated cost of executing them with a. Indexes of the queried tables in the database if the data comes from a database b. Statistics about the views such as number of rows, number of NULL values, etc. The [Statistics of the View]( document in the Virtual DataPort Administration Guide will provide further details on enabling the statistics that will be used by the cost-based optimization. Please refer to [Enabling the Cost-Based Optimization]( and [Cost-Based Optimization]( sections of the Virtual DataPort Administration Guide for more information on enabling the cost-based optimization. The [Best Practices to Maximize Performance II: Configuring the Query Optimizer]( Knowledge Base article has more information on getting better performance from your queries with cost-based optimization. Hope this helps!
Denodo Team
21-02-2023 21:03:43 -0500
You must sign in to add an answer. If you do not have an account, you can register here