Alex Peshkov wrote:

> On Tuesday 24 February 2009 17:32, Dmitry Yemanov wrote:
>> Obviously, you cannot truncate the every segment of the compound index
>> before constructing the key, it can be truncated as a whole only.
>
> Why? When values in segment N match, you continue with segment N+1. When they
> do not match, result of comparison does not depend from segment N+1 - exactly
> what we need for compound index. May be I've missed something?

Sorry, that's maybe me who was missing something :-) I suspected some
problems with "greater than" and "less then" range scans, but after more
thinking I failed to find a case that proves me right. So Jim and you
seem being absolutely correct.


Dmitry