A query returns a few rows but performs a large scan. What should the administrator inspect before changing compute size?

Published
  1. The actual plan, predicates, indexes, cardinality estimates, and data distribution
  2. Only the database name
  3. Only the client's screen resolution
  4. Only the backup retention period

Comments — 0