Re: Indexes and Foreign Keys

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in news:1142115991.869498.239820_at_i39g2000cwa.googlegroups.com:

> Creating indexes that will not be used wastes space and adds another
> index that has to be maintained to the target table.
>
> Now any large table with a FK to a volatile (heavy update and delete)
> parent row will require an index on the FK column. Child tables to
> parent tables where the PK or UK is never updated

Hmmm...

I am/was under the opinion that the PK values can NEVER be changed. Received on Sat Mar 11 2006 - 17:07:47 CST