4 ms·
> That means that it will do a full table scan of table a for each record in table b where postal_code = '97000'. The query plan would be either: NESTED LOO
by j-kidd 15y ago
> That means that it will do a full table scan of table a for each record in table b where postal_code = '97000'.
The query plan would be either:
NESTED LOOP
TABLE B
WHERE postal_code = '97000'
TABLE A (index scans)
or:
TABLE A (1 full table scan)
TABLE B
WHERE postal_code = '97000'
What database do you use that would perform multiple full table scans?