You can translate the question and the replies:

Delegating HASH Joins

Related to: Denodo Query Optimizations for the Logical Data Warehouse
I've got a derived view that is re-used in mutiple views. I've identified the code on the sql server side would be most effective at a specified HASH Join. How do I get Denodo to deligate a HASH join to the database (SQLServer)? I've specified a HASH join at the Join Conditions tab AND specifically identified HASH at the Execution plan, but No HASH join is generated on the SQL. How do I accomplish this?
hash join
user
07-02-2018 17:52:02 -0500
code

1 Answer

Hi, Yes, you could create a base view from query following the next steps: * Open the datasource that connects to the MS SQL Server * Click on "Create base view" * Click on "Create from query" * Give a name to the view a write the query using the [join hint for MS SQL Server](https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-join) i.e: SELECT * FROM Product AS p LEFT OUTER HASH JOIN ProductReview AS pr ON p.ProductID = pr.ProductID; Now, the base the base view is created and it will be executed executing the hash join in MS SQL Server. Hope this helps!
Denodo Team
08-02-2018 11:20:28 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here