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: Fri, 08 Jun 2007 20:34:17 +0200
Message-ID: <268j631e04hf9fhrmufdodv6bt2oba0jth@4ax.com> 





On Fri, 08 Jun 2007 09:11:33 -0700, lrobins1_at_frontiernet.net wrote:



>Given that this is the case, will this database suffer much in terms

>of disk/memory I/O, etc. vs using some numeric type for this column?




I dealt with a situation where number(10) was converted to
varchar2(10) left padded with zeroes.


When I set up a pilot wit the correct datatype the I/O was *50*
percent lower.


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Fri Jun 08 2007 - 13:34:17 CDT












Original text of this message













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