performance: Ordering my varchar2 keys...

From: Andreas Koch <mail_at_kochandreas.com>
Date: Fri, 01 Feb 2002 20:01:20 +0100
Message-ID: <a3eotr$5ui$02$1@news.t-online.com>

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 - 13:01:20 CST