NexusDB, just like e.g. BDE with Paradox tables, and a lot of other DBMS,implements TnxTable as a direct cursor into the data.
Filters are evaluated on a record by record basis. This is "as designed". Some other DBMS that don't support the concept of navigational table access simulate it by having a "table" component that internally executes queries.

Home | Site Contents | Documentation | FAQ, Tips & Tricks | NexusDB FAQ | Table based access