Re: Referential indexes

From: Nuno Souto <dbvision@xxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Fri, 28 Jan 2005 21:13:42 +1100

Leonard, George apparently said,on my timestamp of 28/01/2005 8:51 PM:

> Got this query from a developer, or actually they are actually arguing
> with the DBA team.
> 
> Table A - master, acc number field            also only column in PK
> 
> Table B - Child, acc Number Field             acc number is the first
> column in PK, PK contains 2 more columns.
> 
> DBA's are saying we don't need a normal non unique stand alone index on
> the acc Number field for table B.
> 
> Developers want a separate index,
> 
> COMMENT?
> 

Developers are wrong.


-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision@xxxxxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l

References:

Referential indexes
From: Leonard, George

Re: Referential indexes

Other related posts: