Re: Query performance question

  • From: "Ethan Post" <post.ethan@xxxxxxxxx>
  • To: mschmitt@xxxxxxxxxxxx
  • Date: Thu, 2 Mar 2006 17:08:01 -0600

You need to search AskTom for the "rownum" trick also. That would
likely work here since it forces the inner queries to resolve. I use
that one quite a bit. Sorry I don't have more time to test this.

On 3/2/06, Mike Schmitt <mschmitt@xxxxxxxxxxxx> wrote:
>
> There have been a number of good ideas on how to rewrite the query.  I plan
> to test them out later to help me learn.  My query writing ability is
> probably a 0 out of 10.
>
--
//www.freelists.org/webpage/oracle-l


Other related posts: