Re: performance: Ordering my varchar2 keys...

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Fri, 01 Feb 2002 16:45:55 +0000
Message-ID: <3C5AC643.C789269A@exesolutions.com>

Only insofar as the way it may be indexed or stored. Look at reverse key indexes for an explanation of what may be different.

Daniel Morgan

Andreas Koch wrote:

> Hi,
>
> has the character order of textual keys an performance
> hit.
>
> E.g. is there a difference between having
>
> 20020201AAA
> 20020201AAB
> 20020201AAC
> 20020201AAD
> 20020201AAE
>
> as a key column instead of
> AAA20020201
> BAA20020201
> CAA20020201
> DAA20020201
> EAA20020201
>
> Consideration: In the top list, when joining oracle has to
> check 11 bytes to see the keys are different, on the
> bottom list only the first byte.
>
> --
> Andreas
> LINUX users tune their system for stability
> WIN users tune their system for fast booting
> What you prefer is just a matter of taste.
Received on Fri Feb 01 2002 - 10:45:55 CST