Re: What's this...varchar2 as fast as char?

In article <32FA0D54.7504_at_bell-atl.com>,

   Sean Emery <sean.c.emery_at_bell-atl.com> wrote:
>two oracle consultants informed us that we should probably never use a
>char field because varchar2 fields are just as fast inside an Oracle DB
>and you never have to rtrim() them.
>
>This is quite contrary to what I have believed for a long time now.

you should not use char because it takes more space than varchar. now if you need to process 1 million rows of character data, what would take less time: to read all the disk blocks of trailing, useless spaces; or disk blocks packed with just the significant portion of the data? right.

--
Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.