suppose you have an entity that holds a reference to another entity which in turn contains e.g. a date field you want to query for. Is there an improvement in performance if I create a "mirror" date field in the original entity, removing the need to traverse through the referenced other entity?
So, querying for "all objects with object.otherobject.date > 1.1.1980" is slower than "all objects with object.date > 1.1.1980"? Or doesn't this matter, using proper indexing?