You can translate the question and the replies:

multiple parallel branches of Selection plans

Hi Team, I am facing slow performance issue for 1 our interface. we are querying the interface with three columns in where clause where we passing values given below : select * from i_my_interface where col1 = '001' and col2 in (2,2,3,4,5,4,6,7,8,8,3,2) and col3 = 'xyz' now when i see the query execution plan i see multiple selection plan branches has been created on top of my interface view for data retreival. can you please help me rectify this issue . Regards Salman Khan
05-03-2021 09:47:56 -0500

1 Answer

Hi, In Virtual DataPort, when a query is executed, the Execution Plan is selected based on the Query Processing capabilities of the underlying data sources. For example, if the underlying sources involved in the query are traditional RDBMS, then Virtual DataPort will delegate the query processing to the underlying source, as much as possible per the view definition. If the underlying source involves a non-traditional source like API, File system, etc, then the query processing happens in the Virtual layer, which will result in multiple selection plans. In such scenarios, I would review the execution trace, view definition, data sources involved in the query and apply possible changes that could improve the execution by referring to the below sections, * Enable the [Automatic Simplification of Queries]( option to help the Execution Engine to simplify the queries before executing them. * Use [Full Cache]( mode to store the data in any RDBMS, so that the query is delegated. For more details, take a look at [Queries Optimization]( section of Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
08-03-2021 07:32:12 -0500
You must sign in to add an answer. If you do not have an account, you can register here