Re: which column type char,varchar2 is better for index?

> This is not the school work, i just curious about it.
> i can make table and index as you wish, and i might find out the
> differences, and the index structure algorithm from oracle documents.
> i think everyone can do this, what the newsgroup is for?
> if you don't want to answer the question. just ignore it. don't post the
> reply like this.

Main different between char(x) and varchar2(x) is that value inserted into char(x) has always length x (padded with spaces).

Secondly, char(x) could be soon skipped in new version of Oracle DB.

--
TomekB