Hi Helen,

"Helen Borrie" <helebor@...> wrote in message

> You can create DESC primary (and matched order foreign) keys in

Firebird
1.5.

>
> Data in Firebird are not stored in tabular structures at all and

don't
need

> to be. Mixed *sort* orders don't come from indexes in SQL, they are

created

> by your SQL statement specification, in an ORDER BY clause. Speed

can be

> gained for these sorts (sometimes) by defining indexes to support

them,

> e.g. for
>
> order by col1 desc, col3
>
> you might gain some speed by creating a DESC index for col1 and an

ASC

> index for col3.
>

Excellent, thanks.

> 253 for character set NONE, 252 or less for all other character

sets.

> There's a calculator here:
>
> http://www.volny.cz/iprenosil/interbase/ip_ib_indexcalculator.htm

Thanks!
--
--------------------------
Lesley Dean
CapeSoft
www.capesoft.com