Article View: borland.public.interbase.sql
Article #83Re: can I do that with one select statement
From: Wayne Niddery (TeamB)
Date: Wed, 28 May 2008 02:42
Date: Wed, 28 May 2008 02:42
12 lines
1692 bytes
1692 bytes
"Isaac" <no@no.com> wrote in message news:483c6256@newsgroups.borland.com... > Please Mr Maxim Shiryaev confirm if this method is faster than 2 Selects Should be pretty quick to test. Try it. Often there is not way to say positively which is faster, it depends on your tables, anount of data, indexes, etc. -- Wayne Niddery - TeamB (www.teamb.com) Winwright, Inc. (www.winwright.ca)
Technical Details
Message-ID:
<483cc6bf$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<483bca8e@newsgroups.borland.com> <483bf82c@newsgroups.borland.com> <483c12b2@newsgroups.borland.com> <483c6256@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,e4861ce108d51b43 X-Google-Attributes: gid114a0e,domainid0,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit From: "Wayne Niddery \(TeamB\)" <wniddery@chaffaci.on.ca> Newsgroups: borland.public.interbase.sql References: <483bca8e@newsgroups.borland.com> <483bf82c@newsgroups.borland.com> <483c12b2@newsgroups.borland.com> <483c6256@newsgroups.borland.com> In-Reply-To: <483c6256@newsgroups.borland.com> Subject: Re: can I do that with one select statement Date: Tue, 27 May 2008 22:42:52 -0400 Lines: 13 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Windows Mail 6.0.6001.18000 X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18000 NNTP-Posting-Host: 24.137.214.213 Message-ID: <483cc6bf$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1211942591 24.137.214.213 (27 May 2008 19:43:11 -0700) X-Authenticated-User: wniddery Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail X-Original-Bytes: 1510