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. Michael
