Subject | Composite Primary Keys and Indices |
---|---|
Author | Robert DiFalco |
Post date | 2004-07-21T16:51:35Z |
Say I have a composite primary key on two fields, COLUMN_OWNER_ID and
COLUMN_CHILD_ID. Most of the time I will be search on the
COLUMN_OWNER_ID field, do I need to create a separate index on that
column or will the Primary Key declaration be enough?
TIA
R.
COLUMN_CHILD_ID. Most of the time I will be search on the
COLUMN_OWNER_ID field, do I need to create a separate index on that
column or will the Primary Key declaration be enough?
TIA
R.