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

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

From: genegurevich@xxxxxxxxxxxxxxxxxxxxx
To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 23 Mar 2006 09:22:41 -0600

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


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

References:
- Re: Primary Key seems to be harmful for performance
  - From: Terry Sutton

Other related posts:

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