The performance of JOIN query and a query containing a subquery

From: Phper <hi.steven.tu_at_gmail.com>
Date: Wed, 15 Apr 2009 21:18:11 -0700 (PDT)
Message-ID: <a72454b7-4402-4169-8fea-c5f784fb346a_at_x31g2000prc.googlegroups.com>

To optimize the performance, is it better to rewrite a JOIN SQL query as SQL query containing a subquery? Received on Wed Apr 15 2009 - 23:18:11 CDT

This message: [ Message body ]
Next message: Phper: "Re: What's the difference between snapshot and cache?"
Previous message: Simon: "Re: OEM Upgrade from 10.2.0.1 to 10.2.0.5"
Next in thread: Helma: "Re: The performance of JOIN query and a query containing a subquery"
Reply: Helma: "Re: The performance of JOIN query and a query containing a subquery"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message