Re: Database design

In article <01bd2919$ba8ce900$cf0bbac3_at_m3bj1>, Mabel Trigüis <mabelle_at_bluewin.ch> wrote:
>Thank you for your answer.
>1) No, the database is not insert intensive.
>2) The idea is to make it easier to maintain. Having the rules in two
>places will double the work.
>We are thinking about calling the relevant store procedure in
>When-validate-item or when-validate record. The problem is that I am afraid
>Oracle will be very slow calling stored procedures.
>Mabel,

You might look into the dbms.shared_pool_keep to pin things in the SGA.

>
>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry_at_eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the _at_#%*& DBA!