> > if you create an index. no sorting order, will it than be slower

than the same key with a descending or ascending order?

>
> An index is by default ascending. An index with no sorting order

cannot

> exist.
>
> > So, if I need a descending and a descending order key for that

field,

> > then I create 2 keys (desc, asc) or 1 key with no order.

Oops, sorry, I meant indexes here! I meant creating a desc an asc
index.

> Don't confuse indexes and keys. You don't need a key with a

direction;

> you may need an index with ascending or descending direction to

support

> your queries. It very much depends on the SQL statements you use.

Thanks for the info, Tom.