Subject Re: [ib-support] Unique constraint not an index? was Re: Error:Object is in use
Author Ann W. Harrison
At 10:03 PM 3/5/2001 +0100, Ivan Prenosil wrote:

>Although it is hard to imagine database system without indexes,
>the fact is that SQL92 does not know them.

>Indexes are vendor specific extensions (I am not sure about SQL99),
>they are just auxiliary structures intended to speed up some operations.

Ivan is quite right - I didn't think of the standards aspect of the
question. I believe that SQL99 continues to take the same, enlightened,
attitude toward indexes, table spaces, placement rules, etc. They're
not semantic so they don't need to be standard.


We have answers.