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 -> Re: Weird advice : keep varchar2 under 255 bytes ???

Re: Weird advice : keep varchar2 under 255 bytes ???

From: <jernigam_at_kochind.com>
Date: 11 Apr 2005 08:53:08 -0700
Message-ID: <1113234788.571596.313190@o13g2000cwo.googlegroups.com> 





Why would you use one bigger if you don't need it?



In Tom Kyte's book he mentions a few reason for not creating bigger
fields.


1.  Some query tools will format the field based on the size.
2.  Using array fetches will use more memory
Received on Mon Apr 11 2005 - 10:53:08 CDT












Original text of this message













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