Hi

If I have created some index without specifing asceding or
descending there are automatically created ascending, correct ?

Then if I an a table with 2 mio. records with an index on a date
field does a

select * from transaktioner where dato>=something order by dato desc

then the DB would not / can not use the created index, correct ?

To use an index I have to create another one saying it is
descending, correct ?

Michael