At 02:20 PM 9/30/2002 -0400, Thomas Miller wrote:

>So a multicolumn index is by far faster in Oracle when you have an index
>with all the columns in it.

and one of the drawbacks of the versioning engine is that
finding an entry in the index doesn't mean that the value
is legitimate for your transaction, so we always have to
read the "real" data.

Regards,

Ann
www.ibphoenix.com
We have answers.