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: Primary Key seems to be harmful for performance - THANKS!

Re: Primary Key seems to be harmful for performance - THANKS!

From: <genegurevich_at_discoverfinancial.com>
Date: Thu, 23 Mar 2006 09:22:41 -0600
Message-ID: <OFC39C0EE6.40E687D4-ON8625713A.00544990-8625713A.00547805@discoverfinancial.com> 





Everyone:



I have found out that when I set the _optimized_cost_model parameter to CPU
the same SQL (with no changes)


completes in under 10sec. Thanks to all who replied  - Igor, Terry,
Wolfgang, Mladen and Kevin



thank you



Gene Gurevich



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


Received on Thu Mar 23 2006 - 09:22:41 CST












Original text of this message













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