Re: all foreign key should have index?

> No. But better SQL products construct a "PK=FK" index under the
> covers for you.

Do you have a list of those?

Is it configurable? I'm not sure I want my rdbms generating a 5GB index on
my foreign key when I might not require it.

Backup bloat to start with.

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"-CELKO-" <jcelko212@xxxxxxxxxxxxx> wrote in message
news:1138687059.234890.22280@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>> Is it necessary that all foreign key should have index? <<
>
> No. But better SQL products construct a "PK=FK" index under the
> covers for you.
>


.

Relevant Pages

  • SQL query correctness/efficiency of my query
    ... pk in item master and the foreign key in the other 2. ... I am using Oracle 9i. ... Thanks Rob ... Prev by Date: ...
    (comp.databases.oracle.server)
  • Re: One-to-Many Help
    ... >properties (Customer, etc) that I put in 10 different table columns. ... new business requirements require that each PN be provided ... CN <foreign key to Characteristics> ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
  • Does RI with nullable FKs really work?????
    ... I've taken RI off all my relationships in which the foreign key can be null, ... I'd be amazed if Access did not permit RI on nullable FKs, ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
  • Test if Data for a Field is UNIQUE
    ... I want to create a Foreign Key and base it on an existing field ... Can someone please share SQL that can be used to determine if the ... Michael42 ... Prev by Date: ...
    (comp.databases.oracle.server)