What do you mean by RI on the client side? Does this mean you will take care of deleting child records yourself? If you do this, then you leave yourself vulnerable to users accessing your data using a tool outside your app, deleting a parent record and leaving orphans. I would create Foreign Keys on the child tables and allow Oracle to cascade deletes.
>I have 5 user tables and I will be using RI on the client side.
>Do i need to create appropriate indexes on the ORACLE tables?
>
>my User tables
>
>PHONE_BOOK
>SERVICEREQUEST
>WORKORDER
>WOSTATUS
>SRSTATUS
>
>
>
>Regards
>
>Dejan
Mark McCasland
Midlothian, TX USA