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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
