Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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 DBAReceived on Sat Jun 09 2007 - 00:39:19 CDT
![]() |
![]() |