RE: TKPROF output -- high current gets for INSERT

 Yes..each FK has a local bitmap index but every bitmap index for that  partition that is being loaded is made unusable and we have a trigger  at
 a statement level which issues a
 alter session skip_unusable_indexes=true    

> On Thu, 30 Dec 2004 08:01:53 -0600, "Cary Millsap"
> <cary.millsap_at_hotsos.com> said:
> Doesn't each RE constraint use an index?
>
>
> Cary Millsap
> Hotsos Enterprises, Ltd.

--
http://www.freelists.org/webpage/oracle-l