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?