Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Navigation question

Re: Navigation question

From: Marshall <marshall.spight_at_gmail.com>
Date: 14 Feb 2007 16:15:23 -0800
Message-ID: <1171498523.412371.66310@h3g2000cwc.googlegroups.com>


On Feb 14, 1:59 pm, "dawn" <dawnwolth..._at_gmail.com> wrote:
> On Feb 14, 3:32 pm, "Marshall" <marshall.spi..._at_gmail.com> wrote:
> I have not seen any
> applications that execute exactly one or even only (unordered) sets of
> SQL statements,

Any two SQL queries where query B is parameterized by data retrieved by query A can be rewritten into a single query. The rewritten single query will (absent pathological behavior in the query optimizer) be at least as fast as the sum of the two original queries, and possibly faster. Network utilization will necessarily be at least a little better.

Marshall Received on Wed Feb 14 2007 - 18:15:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US