Re: Navigation question
From: Marshall <marshall.spight_at_gmail.com>
Date: 14 Feb 2007 16:15:23 -0800
Message-ID: <1171498523.412371.66310_at_h3g2000cwc.googlegroups.com>
Date: 14 Feb 2007 16:15:23 -0800
Message-ID: <1171498523.412371.66310_at_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 Thu Feb 15 2007 - 01:15:23 CET