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 -> CHAR v. VARCHAR2: Space or Performance Optimization

CHAR v. VARCHAR2: Space or Performance Optimization

From: Eric A. Stephens <estephen_at_javaboy.appliedtheory.com>
Date: 1997/07/09
Message-ID: <m3g1to2rju.fsf@javaboy.appliedtheory.com>#1/1 







We are designing a fairly large DB and have concluded that using 
VARCHAR2 for all character data is acceptable since Oracle needs
to store some data length information in each row piece in the
data blocks.



Is this a correct assumption?



TIA


-- 
Eric A. Stephens                      estephen_at_AppliedTheory.com
Software Engineering Group          http://www.AppliedTheory.com
AppliedTheory Communications, Inc.


Received on Wed Jul 09 1997 - 00:00:00 CDT












Original text of this message













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