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

Home -> Community -> Usenet -> c.d.o.server -> Magic of varchar2

Magic of varchar2

From: <milind.namjoshi_at_trans.ge.com>
Date: 14 Mar 2006 13:57:16 -0800
Message-ID: <1142373436.710064.30040@j52g2000cwj.googlegroups.com> 






What difference does it make :



    
  
  1.   I define a column as varchar2(500) and store only 10 bytes

  
  2.   I define that column as varchar2(10) .






Any impact on storage / performance ?



My data is static no updates happen once the data is inserted. So no
row chaining.
Received on Tue Mar 14 2006 - 15:57:16 CST












Original text of this message













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