Q&A BY TAG 'left join'

You must sign in to ask a question. If you do not have an account, you can register here

Filtering Left Outer Joins with Automatic Simplification of Queries enabled causing execution plan to be complex
answered 10-09-2020 08:38:26 -0400

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...

Answers: 1

Filter left join Query Simplification

For left join, do we need to create associations to remove not required Join
answered 01-07-2020 15:45:57 -0400

Questions for Asssociation I have one view (v) creating by one fact table (Table F) left join several dimension tables (Table A, B, C, D), I define PK for the fact and all dimesion tables. I have not defined associats for them, when I ran this: "sele...

Answers: 2

left join Associations