Solutions requiring full table scans