|Subject||Re: some index questions|
> > if you create an index. no sorting order, will it than be slowerthan the same key with a descending or ascending order?
> An index is by default ascending. An index with no sorting order
> > 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 adirection;
> you may need an index with ascending or descending direction tosupport
> your queries. It very much depends on the SQL statements you use.Thanks for the info, Tom.