Re: Connection Constraint - Index

And what is even more amazing: in my Oracle 8.1.5 on NT 4.0 it is the second one.

So there is a real need for finding out where the connection between the constraint and the index is recorded and retrievable for programmers and DBAs.

Does anyone know this connection view?

Martin

Violin wrote:
>
> On Fri, 18 Feb 2000 18:12:48 -0000, "Jonathan Lewis"
> <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> Hello,
> I test in 805,
> it is the first one,so amazing!
>
> Viollin.
> violin.hsiao_at_mail.pouchen.com.tw
>
> > The last one you created
> >or The first one you created
> >or The one with the columns in the order of the constraint
> >or The one with the columns in the reverse order of the constraint
> >
> >Traditionally you might expect to create three indexes
> > (a,b,c)
> > (b,c)
> > (c)
> >
> >Rather than three indexes with three columns each
Received on Sat Feb 19 2000 - 04:42:22 CST