Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: char vs varchar2
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