Re: PK vs Unique index

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 17 Jan 2002 11:42:55 -0800
Message-ID: <a279fv0177t@drn.newsguy.com>

In article <m3wuyh2d1p.fsf_at_colorado.arsdigita.de>, Dirk says...
>
><non-unique primary key indexes>
>
>Can you give me a "real-life" example where that can be useful?

update cascade (needs a deferable constraint)

snapshot refreshes (doesn't replay entire transactions -- just pulls last values, can result in temporary inconsistencies that will be resolved by the time you commit)

are two that pop into my head right off

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Thu Jan 17 2002 - 13:42:55 CST