Re: The performance of JOIN query and a query containing a subquery

From: Helma <>
Date: Thu, 16 Apr 2009 00:51:58 -0700 (PDT)
Message-ID: <>

On Apr 16, 6:18 am, Phper <> wrote:
> To optimize the performance, is it better to rewrite a JOIN SQL query
> as SQL query containing a subquery?

Do you really want to program on ROT? (Rules Of Thumb). You may consider to experiment with your specific SQL statement. So 10046- trace your SQL or use autotrace or use explain plan to see the resource consumption of your query. Received on Thu Apr 16 2009 - 02:51:58 CDT

Original text of this message