| Subject | Re: [firebird-support] LEFT OUTER JOIN speed on a simple query |
|---|---|
| Author | Michael Ludwig |
| Post date | 2010-05-13T16:30:59Z |
SoftTech schrieb am 13.05.2010 um 10:27:29 (-0500):
INSERT INTO ZIP_CODE VALUES ( -1, '-' );
UPDATE ADDRESS
SET ZIP_CODE_ID = -1
WHERE ZIP_CODE_ID IS NULL;
And then reexecute your query?
--
Michael Ludwig
> Simply changing the LEFT OUTER JOIN to a JOIN is instant. The issue isWhat happens when you do the following:
> there are 203 addresses in the ADDRESS database that do not have the
> ZIP_CODE_ID set.
>
> Any ideas on how to speed this query up when using the LEFT OUTER JOIN?
INSERT INTO ZIP_CODE VALUES ( -1, '-' );
UPDATE ADDRESS
SET ZIP_CODE_ID = -1
WHERE ZIP_CODE_ID IS NULL;
And then reexecute your query?
--
Michael Ludwig