Conclusions
•The index used to reach the first
event-related table in the join order should use some
column condition correlating to recent rows (potentially combined
with conditions unrelated to time, if a multi-column index applies).
•The rest of the
event-related tables should be reached, usually, with nested
loops to join keys, reaching related recent master and detail
data for the same global recent events.