Hi,

At April 1, 2004, 16:58, Martijn Tonies wrote:

>> >> 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.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)