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

Jaguk Ku wrote:

> hi there,
>
> if there are two columns A and B, A is defined as char(10), B is defined as
> varchar2(10)
> if when i create indexes for both of them. which one has better performance,
> and why?
>
> I think it's not much different, if the index is made with b-tree algorithm.
>
> Would anyone teach me what is different and which one is better and why?
>
> Thanks in advance,
>
> Jaguk Ku

This is school work and your instructor expects you to build two tables, create a loop, and test this out and learn from what you observe.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)