> > > > > You can create DESC primary (and matched order foreign) keys in
> >Firebird
> > > >1.5.
> > > >
> > > >Oh yes, I forgot about that one. Quick question (and without trying):
> > > >what happens if you mix an ASC FK index with a DESC PK index?
> > >
> > > Read my statement again....and give yourself a Bamsemum, quick!!
> >
> >Sorry. still don't get it (don't have any Bamsemums though)...
> >
> >If you create an FK that points to a DESC PK, will it automatically
> >create a DESC FK?
>
> No; it means if you create a USING <indexname> DESC primary key, any
> foreign keys pointing to it must also be USING <indexname> DESC (as
> explained in the release notes).

ok - this is what I thought you were saying. My question was:
what happens if they don't match?

> Is that better for you than a B*m****M? Or nearly as good?

Not quite as good ;-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com