You can translate the question and the replies:

Limitations on derived view (JOIN)

Hi All, we have derived view (JOIN) created with 15 tables (14 joins) and planning add additional logic which will bring 10-15 joins additonally . Could you please let me know if there will be any limitaion on that ? Thanks, Ravi
hash join join limitation
user
25-01-2023 06:30:58 -0500
code

1 Answer

Hi, Denodo does not have any restriction to join the view additionally. The query fetched from the underlying data source may takes a little bit more time if you perform multiple join operation. For more information, you can refer to the [**Optimizing Join Operations**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/optimizing_queries/optimizing_join_operations/optimizing_join_operations#optimizing-join-operations) section under the Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
25-01-2023 08:16:47 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here