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: Varchar2 vs Char

Re: Varchar2 vs Char

From: Ellen Russell <Ellen_Russell_at_dg.com>
Date: 1997/05/11
Message-ID: <01bc5da8$8d2f2fa0$3534dd80@EllenRus.us.dg.com>#1/1

Check the parameters you've used to create the table. If you've set them correctly you won't take a performance hit. However, if you're parameters don't take into account the growth of your rows you will take a hit.

Jerry Veno <k77048_at_phxbs003.phx1.aro.allied.com> wrote in article <5ktefm$qgb_at_asbe05.phx1.aro.allied.com>...
>
> I've been getting feedback from the developers arguing that using
 varchar2
> instead of char when defining a table is taking a performance hit. Does
 anyone
> have any info they could provide on this subject?
> Thanks for any help,
> Jerry Veno
>
Received on Sun May 11 1997 - 00:00:00 CDT

Original text of this message

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