AnsweredAssumed Answered

Order of relationship criteria and speed

Question asked by smith7180 on Oct 31, 2015
Latest reply on Nov 1, 2015 by Vincent_L

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?

Outcomes