Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Table Replicated,index not used-BitOld

Re: Table Replicated,index not used-BitOld

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Wed, 7 Sep 2005 15:26:13 -0400
Message-ID: <BAY103-DAV332B46554CE20236F944AA6A60@phx.gbl> 





Table Replicated,index not used-BitOldAre both table parallel enabled? I
would try making them non-parallel. I've had this problem many times. Oracle
really favours full table scans when the tables are parallel enabled.



Mike

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


Received on Wed Sep 07 2005 - 14:28:22 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US