Re: Join/Datatype Performance Considerations

:

That is not necessarily true for Oracle. Oracle store numbers in its own exponential notation so it has to use different comparison mechanisms. The only advantage of using the number datatype in joins would be that it usually takes fewer bytes to represent a number then a VARCHAR2. As a result, there will be fewer bytes to compare.

Raju Patel

randyd_at_cais3.cais.com (Randy Dewoolfson) wrote:
>KevinWaters_at_DRS_at_CPLISD wrote:
>: Is anyone aware of a performance differential in joining two tables on VARCHAR2 columns versus joining them on NUMERIC columns?
 

>
>Here's a real non-technical answer for ya-
>use numbers.
>If you're a computer you can easily check two numbers...
>you need to check each character in a string one by one in a loop...
>The varchars will be slower...
>Randy :)
>
>--
> ..uu. ----------------------
> .?$" '?i . I Randy DeWoolfson I
> .T^M ._at_" d9 . f ,.un. b, i I--------------------I
> " Z :#" M `8 U < .dP"``"# `M _at_" I randyd_at_cais.com I
> &H?` Xl _R $5. $ ?* _at_ 'P,#" I--------------------I
> ,d#^*L :RP'~$b f`$L:M Xf .f' dH` I ,\//. I
> & 'M ,P `E M "$ Mux~ n!` I |o o| I
> dk `h" ' j " y" *~ I====oOO==(_)==Ooo===I
>
Received on Fri Jan 05 1996 - 00:00:00 CET