Mid SQL Reducing Full Table Scans: If a query frequently performs full table scans, adding? an index on the filtering columns can improve performance.