When is a full table scan preferable to an index seek?

SQL Data Analyst Hard

SQL Data Analyst — Hard

When is a full table scan preferable to an index seek?

Key points

  • Full table scan is efficient for fetching a large number of rows
  • Index seek is better for specific, targeted queries
  • Understanding the data retrieval pattern is crucial in choosing the right method

Ready to go further?

Start full exam Practice more questions

Related questions