Re: Referential indexes

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_at_iinet.net.au
--
http://www.freelists.org/webpage/oracle-l