Re: The performance of JOIN query and a query containing a subquery
Date: Thu, 16 Apr 2009 00:51:58 -0700 (PDT)
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