Re: Performance difference between varchar2 and number

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/

        Number data is stored in a modified floating point format. When displaying or comparing conversion is required. although the performance difference may prove too small to measure varchar2 should be faster.

-- 
Jerry Gitomer
Once I learned how to spell DBA, I became one