Subject Re: some index questions
> > 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
> exist.
> > So, if I need a descending and a descending order key for that
> > 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

> Don't confuse indexes and keys. You don't need a key with a
> you may need an index with ascending or descending direction to
> your queries. It very much depends on the SQL statements you use.

Thanks for the info, Tom.