Importance of Column Order in Composite Index
From: David Franit <dfranit_at_hotmail.com>
Date: 30 Oct 2001 13:54:35 -0800
Message-ID: <e3b48e1f.0110301354.97a7a16_at_posting.google.com>
Date: 30 Oct 2001 13:54:35 -0800
Message-ID: <e3b48e1f.0110301354.97a7a16_at_posting.google.com>
Hello,
In Oracle/SAP systems many of the default indexes are setup such
that the rows with low selectivity form the first columns of a composite
index. Frequently,this matches the primary key. For example,
Table ABC has 2,000,000 rows.
(i) A default index on table ABC might contain column X, followed by column Y
Column #X has 3 distinct values.
Column #Y has 30 distinct values.
Column #Z has 10000 distinct values.
and column Z.
Thanks,
D. Franit
Received on Tue Oct 30 2001 - 22:54:35 CET