Re: Primary Key of type string ?

On Fri, 08 Jun 2007 17:02:30 -0700, lrobins1_at_frontiernet.net wrote:

>Forgive me but I am not following.
>Are you saying that all those columns in the tables were converted
>from number to varchar2 and I/O decreased,
>or since the columns were number, you skipped converting them to
>varchar2 and that's what gave you better performance?
>While the second would make more sense to me, I have seen stranger
>things...
>Thank you for your time.

Please try to read:
Obviously the *correct* datatype was *number*(10) instead of varchar2(10).

Also please do not top-post (No, I'm not going to explain what top-posting is)

-- 
Sybrand Bakker
Senior Oracle DBA