Types of Conditions
•Conditions defining data for a single, specific event.
–E.g., “Data for a specific client visit for service”
–These should normally drive from an indexed primary or foreign key that uniquely points to a row mapping to that event.
–The details of that event will need to be reached through indexed foreign keys, with nested loops.
–The “recentness” of the queried data may be non-obvious, but it is almost invariably the case that the specific event queried will be a recent one.
•
•