3 Replies Latest reply on Oct 19, 2016 4:30 AM by L B

    Referential integrity and Join culling

    yogev zilberman

      Join culling….

      Couple of questions:

      1. Do I need to define keys in DB?
      2. I understand joins have to be inner, all joins have to be inner?
      3. If I have 10 tables in my diagram, and 1 join is outer,

      I am taking from 2 tables that are in the inner join,

      Will the join culling work? Means, all join in the diagram must be inner?

       

      * no need to mention that the option of "Referential integrity" in the datasource is on.