Is ORDER BY operation faster if field is indexed?

[Ruslan Zasukhin]

On 27/12/07 10:24 AM, "Steven Ronald" <stevenrt39 at yahoo.com.au> wrote:

Hi Steven,

> Ruslan,
> 
> if I have an SQL query
> 
> valSQLSelect(select foo where bar=23 ORDER BY g)
> 
> will it be faster if the field g is indexed?

1) Yes of course a lots. For any db.

2) in fact Valentina still do trick here.
    for some field types it MARK field to be indexed self.
        
    numeric fields from boolean to ulong/date/time (4 bytes)
    are not marked as indexed and still do very effective sorting.

> Best Regards,
> Steven


-- 
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]