Excellent!
Thank you Wolfgang, for taking the time to build
a test case and sharing it.
Jared
On 5/25/06, Wolfgang Breitling <
breitliw@centrexcc.com> wrote:Several posters have made excellent comments about the use of number datatypes
vs. character datatypes for columns that are, or may be, involved in joins.
First off I want to say that join performance should be (one of) the last
considerations in determining the datatype of a column. The datatype should
first and foremost be appropriate for storing the intended content.
In the other posts the predominant gist was
a) test it
b) numbers ought to have an edge as far as performance is concerned
Now let me give you this testcase: