Multiple choice technology databases

When Sybase IQ generates a query plan, what are the two important values to be checked for each search argument?

  1. Longevity

  2. Selectivity

  3. Productivity

  4. Usefulness

Reveal answer Fill a bubble to check yourself
B,D Correct answer
Explanation

Selectivity estimates the fraction of rows matching a predicate, crucial for cost-based optimization. Usefulness indicates how effectively a search argument filters the result set. Together they guide the optimizer in choosing efficient access paths.