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