Latest Activity

code

Filtering Left Outer Joins with Automatic Simplification of Queries enabled causing execution plan to be complex

My development team is seeing strange behaviour with Denodo execution plans when using left outer joins and filters. We have a query that has multiple left joins to get data from a lookup table. When we execute the query, it takes approximately 20 se...

Filter left join Query Simplification

code

Query Simplification

Hello, I have a scenario where I need to "Simply a Query" based on selection. For example I have two base views, first one named "bv_first_view" (with field names - id, name, age, address) , second base view named "bv_second_view" (with field names - ...

DB2 Query Simplification