Re: Key Compression vs. Selectivity

On 15.12.2006 13:15, Jonathan Lewis wrote:
> "Robert Klemme" <shortcutter_at_googlemail.com> wrote in message
> news:4uf9uoF17a65cU1_at_mid.individual.net...
[...]
> Richard,
>
> The "most selective first" has always been a little
> flexible (at least since 6.0 appeared)

Yeah, in the case I am pondering there is a TIMESTAMP column as first column because queries typically cover only a certain time range. It's probably not the most selective column though.

 > and your
> basic reasoning is correct.
>
> A couple of references you might want to look at:
> http://www.jlcomp.demon.co.uk/ch_07.html
> (see the item on index compression)
> and
> http://www.jlcomp.demon.co.uk/faq/compress_ind.html

Thank you, James! ;-)

SCNR         robert Received on Fri Dec 15 2006 - 07:13:19 CST