Greetings Michael,

I'm sure this would most likely help, but would like to see if I can find any other way to handle this before trying it.

Thanks for your reply,
Mike

----- Original Message -----
From: Michael Ludwig
To: firebird-support@yahoogroups.com
Sent: Thursday, May 13, 2010 11:30 AM
Subject: {Disarmed} Re: [firebird-support] LEFT OUTER JOIN speed on a simple query



SoftTech schrieb am 13.05.2010 um 10:27:29 (-0500):

> Simply changing the LEFT OUTER JOIN to a JOIN is instant. The issue is
> 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?

What happens when you do the following:

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



--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

[Non-text portions of this message have been removed]