Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Primary Key of type string ?

Re: Primary Key of type string ?

From: <sybrandb_at_hccnet.nl>
Date: Sat, 09 Jun 2007 07:39:19 +0200
Message-ID: <o4fk63d9smbff27j6h46f8v8bvajse6gr6@4ax.com>


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
Received on Sat Jun 09 2007 - 00:39:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US