I found my mistake. My supposition is working only if value column in t1
table is unique. But if I replace the index by unique one then plan is the
same.
On Mon, May 3, 2010 at 5:57 PM, Alexander Korotkov wrote:
> Well, no, because that plan wouldn't produce the specified ordering;
>
> Well, no, because that plan wouldn't produce the specified ordering;
> or at least it would be a lucky coincidence if it did. It's only
> sorting on t1.value.
>
I just don't find why it is coincidence. I think that such plan will always
produce result ordered by two columns, because such neste
