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.


Regards,

Ann
www.ibphoenix.com
We have answers.