Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: which column type char,varchar2 is better for index?

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

From: Jaguk Ku <jkku_at_kynax.com>
Date: Fri, 11 Jun 2004 11:23:19 +0900
Message-ID: <cab23d$d8r$1@news1.kornet.net>


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.

Jaguk Ku

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1086915921.985866_at_yasure...
> 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)
>
Received on Thu Jun 10 2004 - 21:23:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US