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: char vs varchar2

Re: char vs varchar2

From: David Sharples <david.sharples3_at_ntlworld.com>
Date: Tue, 3 Dec 2002 20:45:53 -0000
Message-ID: <6VWw9.2259$%q2.85418@newsfep1-win.server.ntli.net>


have a quick look at this

http://asktom.oracle.com/pls/ask/f?p=4950:8:1536998::NO::F4950_P8_DISPLAYID, F4950_P8_CRITERIA:173612348069, "Murty Adavi" <adavi_at_attbi.com> wrote in message news:FoUw9.224547$%d2.75129_at_sccrnsc01...
> Version : Oracle 8i
> I have table a with an in index on a 'char' field. Will there be any
> difference in index performace
> based on whether a column is char as opposed to varchar2 ?
> I know that the 'comparison semantics' differ for char & varchar2 but
I
> would like to know the
> difference between char & varchar2 from performance stand point.
>
> Thanks
>
>
>
Received on Tue Dec 03 2002 - 14:45:53 CST

Original text of this message

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