2 Replies Latest reply on Nov 1, 2015 2:34 AM by Vincent_L

    Order of relationship criteria and speed


      Let's say I have a relationships with multiple criteria.  One is a simple primary key - foreign key criterion.  Another is a list to list criterion (ie OR) where TableA::FieldA = TableB::FieldB and both fields are lists (carriage return separated values).  There are no unstored calcs or globals involved in anyway. 


      If the 'simple' criteria comes first, does the relationship perform better?