Re: optimizing the sequence of index fields

In article <5j8omc$d4t@nntpb.cb.lucent.com>, Midnight Sunburst <sicherman@lucent.com> writes >We're having poor performance when tracing is turned on for an index >whose first field has thousands of identical values. > >It seems as if a multiple-field index will be more efficient >if the values of the first field are highly varied - but I never Correct. >can tell with Informix! Is there a reliable way to sequence the >fields in an index for efficiency? Always put the most unique parts of the key first (assuming the most unique part with always be used. > >-:- > "You have SECONDS to live, Cynicalman! Use them wisely!" > "OK, I'll get my socks out of the dryer." -- David Williams