Re: Do I need this index?
Date: Tue, 20 Nov 2001 01:05:36 GMT
Message-ID: <A%hK7.47227$XJ4.28235622_at_news1.sttln1.wa.home.com>
No. You are correct you do not need an index on just folderid.
Jim
"jim nash" <jim_nash_at_yahoo.com> wrote in message
news:6ef12c.0111191645.3eedfee5_at_posting.google.com...
> I have a table defined as:
>
> CREATE TABLE FOLDERENVELOPES(
> FOLDERID INTEGER Not Null,
> ENVELOPEID INTEGER Not Null,
> CONSTRAINT PK_FOLDERENVELOPES PRIMARY KEY ( FOLDERID, ENVELOPEID )
> );
>
> CREATE INDEX IX_FOLDERFOLDERCID ON FOLDERENVELOPES( FOLDERID );
>
> CREATE INDEX IX_FOLDERENVELOPECID ON FOLDERENVELOPES( ENVELOPEID );
>
> The table may have several hundred thousand rows.
>
> As the primary key may used for indexed access via both FOLDERID and
> {FOLDERID, ENVELOPEID}, is there any value to IX_FOLDERFOLDERCID ?
>
> Thx
>
> - Jim
Received on Tue Nov 20 2001 - 02:05:36 CET