Why is searching for large-table full-table scans critical to SQL tuning?
They indicate an optimized execution plan.
They may be able to be tuned to use an index
The full-table scan should be normalized from the database design
A full-table scan is always sub-optimal.