> >> >> 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.
>
> My remarks were mainly due to the wording being used ("Standard
> syntax") as seen above. My response wasn't directed towards you, but
> to reinforce what you said.:) And, it was just to mention that there are
> no standard SQL syntax for creating or managing an index.

Well, we sure agree on that one then :-)

With regards,

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