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

Home -> Community -> Usenet -> c.d.o.misc -> Strange Oracle Optimization

Strange Oracle Optimization

From: Kin Ng <kin_ng5_at_yahoo.com>
Date: 12 Jul 2003 12:16:07 -0700
Message-ID: <d5b3f600.0307121116.283114b1@posting.google.com> 





I have a complex query that takes a really long time to run and
actually never completed because it ran out of space.  But if I add
this meaningless (oh well, may be meaningful) condition in the
existing Where clause, the query returns data in a few seconds.



and ROWNUM > 0



Why adding this makes a query run so much faster?
Received on Sat Jul 12 2003 - 14:16:07 CDT












Original text of this message













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