Re: Finding out about indexes from system tables

From: Andrew Hardy <nobody_at_spam.from.news.AdvanticaTech.com>
Date: Fri, 20 Jul 2001 09:31:21 +0100
Message-ID: <9j8q96$e51$1@sun-cc204.lut.ac.uk>

"Stan Brown" <stanb_at_panix.com> wrote in message news:9j7tcl$f7q$1_at_panix3.panix.com...
> In <tle416qk5brk10_at_beta-news.demon.nl> "Sybrand Bakker"
<postbus_at_sybrandb.demon.nl> writes:
>
>
> >"Stan Brown" <stanb_at_panix.com> wrote in message
> >news:9j71i1$bpg$1_at_panix6.panix.com...
> >> In <9j6ope$sf9$1_at_sun-cc204.lut.ac.uk> "Andrew Hardy"
> >>
> >> Thanks for the _FAST_ response.
> >>

> >The first column in the constraint is in position 1 and so on.
>
>
> OK, but is this significant? If so, how?

Tables can have multiple columns making up the primary key, the position indicates the order of the columns in the key. This is mainly of interest when using the indexes e.g. making queries that have best chance of using the index on the primary key.

Andy Received on Fri Jul 20 2001 - 03:31:21 CDT