Do I need this index?
From: jim nash <jim_nash_at_yahoo.com>
Date: 19 Nov 2001 16:45:12 -0800
Message-ID: <6ef12c.0111191645.3eedfee5_at_posting.google.com>
Date: 19 Nov 2001 16:45:12 -0800
Message-ID: <6ef12c.0111191645.3eedfee5_at_posting.google.com>
I have a table defined as:
CREATE TABLE FOLDERENVELOPES(
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 ?
FOLDERID INTEGER Not Null,
ENVELOPEID INTEGER Not Null,
CONSTRAINT PK_FOLDERENVELOPES PRIMARY KEY ( FOLDERID, ENVELOPEID )
);
Thx
- Jim