Is ORDER BY operation faster if field is indexed?

[Steven Ronald]

Ruslan,

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 index

Is it also true that the MAX, MIN operations are
faster on an indexed field?

Best Regards,
Steven





      Make the switch to the world's best email. Get the new Yahoo!7 Mail now. www.yahoo7.com.au/worldsbestemail