You can translate the question and the replies:

How does Data Movement work dynamically?

My question is regarding data movement without using the CONTEXT (DATAMOVEMENT) clause. I've been working with data movement to improve performance in a query using a view with a large amount of data joined to a view with a much smaller amount of data. Both views have data movement enabled at the data source connection and statistics enabled in each view. I've been able to manually force the data movement using the CONTEXT( DATAMOVEMENTPLAN ) clause and it executes the data movement as expected as evidenced by the execution trace. I've been able to replicate this experience using this CONTEXT clause when joining other views to this very large table. However, I am not able to get data movement to work dynamically without using the CONTEXT clause. Is there a specific criteria (number or records, size of data) that will dynamically envoke data movement on ad-hoc queries if data movement is enabled in the data source connection?
user
23-09-2022 17:55:34 -0400
code

1 Answer

Hi, For your scenario, I would like to let you know that forcing the Data Movement is the only possible way for utilizing this optimization in Denodo. Dynamic way of invoking Data Movement is not possible at the moment. For more information, you can refer to [**Data Movement** ](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/optimizing_queries/data_movement/data_movement) section of the Virtual DataPort Administration Guide. If you are a valid support user, I would recommend you to raise a enhancement request case in [**Denodo Support site**](https://support.denodo.com/) to request for this automatic invoking of Data Movement. Hope this helps!!
Denodo Team
26-09-2022 07:48:17 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here