Class E206_WhereRedbNarrowsFirst
WhereRedb narrows first. A condition on the object's own columns (here the parent) is checked
on _objects before any Props field is read, so the query reads the fields of the few objects
that pass and nothing else. The same Props filter and page over the whole scheme reads every
employee. This is the shape of "the points of one route sorted by their number" or "the lines
of one order": a narrow parent, a Props filter, a page sorted by a Props field.
[ExampleMeta("E206", "WhereRedb - Narrow by Parent First", "Query", ExampleTier.Free, 1, new string[] { "WhereRedb", "ParentId", "Performance", "Composite" }, RelatedApis = new string[] { "IRedbQueryable.WhereRedb", "IRedbQueryable.Where", "IRedbQueryable.ToSqlStringAsync" })]
public class E206_WhereRedbNarrowsFirst : ExampleBase
Inheritance
Inherited Members
Methods
RunAsync(IRedbService)
Run the example and return result.
public override Task<ExampleResult> RunAsync(IRedbService redb)