Subject Unique constraint not an index? was Re: Error:Object is in use
--- In ib-support@y..., "Ivan Prenosil" <prenosil@m...> wrote:
> Although it is hard to imagine database system without indexes,
> the fact is that SQL92 does not know them.
> Standard SQL language describes what results you are interested in
> (like that you want values in column to be unique=unique
> but does not care about implemetation details (like that you want
> to create index to speed up query or to enforce uniqueness).
> Indexes are vendor specific extensions (I am not sure about SQL99),
> they are just auxiliary structures intended to speed up some

Correct, and still true in SQL99.