Multiple choice technology databases

Why is searching for large-table full-table scans critical to SQL tuning?

  1. They indicate an optimized execution plan.

  2. They may be able to be tuned to use an index

  3. The full-table scan should be normalized from the database design

  4. A full-table scan is always sub-optimal.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Full-table scans on large tables read every row, which is expensive. Identifying these scans is critical because they can often be optimized by creating or using appropriate indexes. Indexes allow the database to read only relevant rows instead of scanning the entire table.

Keep practicing — related questions