ianal Vista wrote:
> "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.
Can NEVER is not correct.
Should NEVER is quite another matter entirely.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sun Mar 12 2006 - 15:08:05 CST
