Simple doubt about ORDER BY

[Ruslan Zasukhin]

On 1/12/06 8:13 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

> On 1/12/06 8:10 PM, "Stan Busk" <maxprog at mac.com> wrote:
> 
> Hi Stan,
>  
>> Am I right to think Valentina returns entries sorted by RecID when
>> the sorted column values are identical? It looks like it behave that
>> way. Just to make sure.
> 
> Probably, although this is NOT a target.
> So do not depend on this.

Stan, I am wrong. 

Valentina really do all its best to get records sorted by RecID.
Actually this is natural order for many algorithms, so no additional
overhead. 

The same is true for joins.

This is because always it is better iterate forward then backward.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]