Answers are grounded in this paper and cite their sources.
In large federated and shared-nothing databases, resources can exhibit widely fluctuating characteristics. Assumptions made at the time a query is submitted will rarely hold throughout the duration of query processing. As a result, traditional static query optimization and execution techniques are ineffective in these environments.
No takes yet. Share an insight, caveat, or question.
Avnur et al. (2000) studied this question.