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.
--
http://www.freelists.org/webpage/oracle-l
- References:
- RE: TKPROF output -- high current gets for INSERT
- From: Cary Millsap
Other related posts:
- » TKPROF output -- high current gets for INSERT
- » RE: TKPROF output -- high current gets for INSERT
- » Re: TKPROF output -- high current gets for INSERT
- » RE: TKPROF output -- high current gets for INSERT
- » RE: TKPROF output -- high current gets for INSERT
- » Re: TKPROF output -- high current gets for INSERT
- » Re: TKPROF output -- high current gets for INSERT
- » Re: TKPROF output -- high current gets for INSERT
- » Re: TKPROF output -- high current gets for INSERT
- » Re: TKPROF output -- high current gets for INSERT
- » Re: TKPROF output -- high current gets for INSERT
- » Re: TKPROF output -- high current gets for INSERT
- » Re: TKPROF output -- high current gets for INSERT
- » Re: TKPROF output -- high current gets for INSERT
- RE: TKPROF output -- high current gets for INSERT
- From: Cary Millsap