Subject Re: [firebird-support] Re: LEFT OUTER JOIN is extremely slow.
Author Michael Ludwig
Ray Holme schrieb am 30.04.2012 um 19:15 (-0400):
> If you want performance too, make as many of your join criteria
> numerical and of the same type. I try to search on strings but join
> tables on integers (or bigints or shorts, doubles and floats are OK
> but not as good)

Yes. I once was given the advice to always use the native integer type
of the machine for joins. Because that should be fastest.

Guess that 32 bit integers are fine on a 64 bit hardware because that's
such a common requirement.