Re: Index: order of fields

is this something you've picked up from a whitepaper somewhere, or you own experimentation ? I'd be interested to see the proof and the assumptions its based on.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

markp7832_at_my-deja.com wrote in message <88ruko$df2$1_at_nnrp1.deja.com>...
>In article <1104_951125428_at_way>,

>1) When all columns will always be present order them with the most
>selective, i.e., columns with the most distinctive values first. This
>improves the efficiency of b-trieve balancing maintenance.
Received on Mon Feb 21 2000 - 13:05:27 CST