On Tuesday, Feb 25, 2003, at 14:59 US/Eastern, Thomas Mahler wrote:
SO any queries that do a (non-primary key based) criteria lookup, will result in loading the complete extent (all instances of a given class) into memory an then filter all matching instances.
This is even worse than an full table scan in the DBMS!
WOA! instant cartesian product! Scan all rows of all tables you're selecting... Geez! Nice going Sun!
