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/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)