Sorry, I should have been more precise. I intend to use Visual Promatrix RI ( referential Integrity ). It is a front end tool for developing Client/Server apps (
www.promatrix.com). I have an option to let Promatrix handle RI deletes or to make ORACLE cascade deletes and inforce it through Foreign Keys. With Promatrix i can upsize all system tables to ORACLE i.e. tables that are used for DD ( Data Dictionary ). RI will be handled through Remote Views. I think it should work.
As with indexes i understand i will use them as recommended.
Any field that appears in my where clause should have an index in ORACLE table plus PRIMARY index on every table.
Thanks
Dejan