> >> 2. Something else that I haven't proven is that it actually can have
> >> indexes that have are mixed order.
> >> E.G. PK ASC, Date DESC.:
> >> Firebird syntax:
> >> CREATE UNIQUE DESCENDING INDEX IDH_DATE_INSP_DESC ON INSPDHST (PART_NO,
> >> INSP_DATE, INSP_TIME);
> >> Standard syntax:
> >> CREATE UNIQUE INDEX IDH_DATE_INSP_DESC ON admin.INSPDHST ( PART_NO,
> >> INSP_DATE DESC, INSP_TIME DESC);
>
> > Firebird doesn't have mixed ordered indices.
>
> And, I wasn't able to find a CREATE INDEX syntax in the SQL standard
> documents that I have. Even PostgreSQL mentions that there is no
> CREATE INDEX in the SQL-92 standard(and it's their own extension to
> the SQL language), which confirms my findings for SQL-92 and I can
> also confirm the same for SQL-99.

That's because an Index isn't something that has to do with
modelling. An index is a performance thingy.

With regards,

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