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: "order by " clause confuses CBO

Re: "order by " clause confuses CBO

From: Andreas Jung <ajung_at_sz-sb.de>
Date: Wed, 26 Jul 2000 18:18:00 +0200
Message-Id: <10570.113025@fatcity.com> 





On Wed, Jul 26, 2000 at 08:17:11AM -0800, Joseph S. Testa wrote:


> I just went thru the same thing.

> 

> take alook at ur optimizer mode, see if it happens to be defaulted to first_rows, once i set mine back to choose, all was well with the order by

> clause.




No, is is set already to CHOOSE.



Andreas 
Received on Wed Jul 26 2000 - 11:18:00 CDT












Original text of this message













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