Is ORDER BY operation faster if field is indexed?

[Ruslan Zasukhin]

On 28/12/07 4:54 AM, "Steven Ronald" <stevenrt39 at yahoo.com.au> wrote:

Hi Steven,

>> 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 index
> 
> Is it also true that the MAX, MIN operations are
> faster on an indexed field?

Of course.

Easy to see why.

Having on hands index we can just take MIN and MAC value,

Without this, you need scan the whole column of table,
I.e. Todo N comparisons and some M of assignments.



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