RE: TKPROF output -- high current gets for INSERT

  • From: sat0789@xxxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 30 Dec 2004 11:15:21 -0800

 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@xxxxxxxxxx> said:
> Doesn't each RE constraint use an index?
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.

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

Other related posts: