Re: The performance of JOIN query and a query containing a subquery
From: Helma <helma.vinke_at_hotmail.com>
Date: Thu, 16 Apr 2009 00:51:58 -0700 (PDT)
Message-ID: <3bd07e00-3b1a-4b88-b2fe-b0bfa7749ba7_at_y9g2000yqg.googlegroups.com>
On Apr 16, 6:18 am, Phper <hi.steven..._at_gmail.com> wrote:
> To optimize the performance, is it better to rewrite a JOIN SQL query
> as SQL query containing a subquery?
Date: Thu, 16 Apr 2009 00:51:58 -0700 (PDT)
Message-ID: <3bd07e00-3b1a-4b88-b2fe-b0bfa7749ba7_at_y9g2000yqg.googlegroups.com>
On Apr 16, 6:18 am, Phper <hi.steven..._at_gmail.com> 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