Oftentimes, the decision about whether some optimization
is required for a query depends on whether the query returns many
rows. The phrase many rows as used in these tuning guidelines
typically means several thousand rows or more.
Important: Subjective cutoffs apply as well. For example,
the user response time can be a factor in the decision to optimize
a search.