At 07:24 AM 20/11/2003 +0000, you wrote:

>If I issue following statement
>
>Select max(aField) from aTable
>
>and there is an index on afield, it is not used. How can I use an
>index wit above statement ???

The optimizer will use a descending index for this query, if one
exists. It would never use an ascending index.

heLen