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 -> Re: OPTIMIZER_HINT, FIRST_ROWS, and MAX

Re: OPTIMIZER_HINT, FIRST_ROWS, and MAX

From: <athaung_at_gmail.com>
Date: Mon, 12 Nov 2007 06:21:06 -0800
Message-ID: <1194877266.632533.252140@v65g2000hsc.googlegroups.com> 





The Oracle version exhibiting the problem is 8.1.7.0.0.
The problem does NOT show up in 9.2.0.1.0.



Separating out the join of the concatenated values results in 0 rows
returned in both cases.



Is there a better way to do this query?  The basic idea is this:
A table holds a list of Book Ids and Check-Out times.
I want to get a list of the records with the latest Check-Out times
before a given cutoff time, for each Book Id available in the table.



Thanks very much for taking a look,


-Aung
Received on Mon Nov 12 2007 - 08:21:06 CST












Original text of this message













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