Re: Performance difference between varchar2 and number

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: Sat, 26 May 2001 05:15:23 GMT
Message-ID: <3B0F6735.F223A3DB@magicinterface.com>

Depends on how you want to use it. and what performance are you worried about. For a 9 digit number like the SSN then the NUMBER datatype uses less memory and so might use slightly fewer disc reads to search the table. But CPU time might be consumed in converting it to character type for display.

the bottom line is that for performance issues there is no substitute for testing with your own data and programs.

Paul wrote:
>
> Hi,
> When I create a table with column, such as SSN. I am not sure which I
> should use, varchar2 or number. I only foucs performance. Does anybody
> know what difference bewteen using varchar2 or number?
>
> Thanks
>
> Paul
>
> --
> Posted via CNET Help.com
> http://www.help.com/
Received on Sat May 26 2001 - 00:15:23 CDT