Article View: borland.public.interbase.sql
Article #92Re: no current record for fetch operation mining explicit left joins and implicit inner joins
From: Craig Stuntz TeamB
Date: Thu, 29 May 2008 13:33
Date: Thu, 29 May 2008 13:33
18 lines
2049 bytes
2049 bytes
Massimiliano Trezzi wrote: > I agree, but this syntax works with most database engines so why a > tool producer should fix it? Off the top of my head, the best reason that I can think of is that even if it did work, it is likely that performance would be terrible. With an implicit join, the optimizer cannot discriminate well between conscience in the where clause used to filter the completed result set and conscience in the where clause used to specify the join. Garbage in, garbage out. -- Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz Borland newsgroup denizen Sergio Gonz�lez has a new CD of Irish music out, and it's good: http://tinyurl.com/7hgfr
Technical Details
Message-ID:
<483eb0ae$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<483d879c$1@newsgroups.borland.com> <483d8dff$1@newsgroups.borland.com> <483e4c0c@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,c962a98f7a2cfe5f X-Google-Attributes: gid114a0e,domainid0,public,usenet X-Google-Language: ENGLISH,ASCII From: "Craig Stuntz [TeamB]" <craig_stuntz@nospam.please [a.k.a. acm.org]> Subject: Re: no current record for fetch operation mining explicit left joins and implicit inner joins Newsgroups: borland.public.interbase.sql References: <483d879c$1@newsgroups.borland.com> <483d8dff$1@newsgroups.borland.com> <483e4c0c@newsgroups.borland.com> Organization: Vertex Systems Corporation User-Agent: XanaNews/1.18.1.9 X-Face: "huzh55Xi]!ZNni78>a*5+).`SK?<^q2MlHk-C]Z2M9T@\J5ZCB$95Ey+s"XQuhGFA[eutZ:0^AV!Q;t>gE`1-=8d;HZ6~*o1dH<X9\b$!|(}+I'!Xq)@3Op}%0ArW&nf'Qh*EwR MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit NNTP-Posting-Host: 64.199.116.234 Message-ID: <483eb0ae$1@newsgroups.borland.com> Date: 29 May 2008 06:33:34 -0700 X-Trace: newsgroups.borland.com 1212068014 64.199.116.234 (29 May 2008 06:33:34 -0700) Lines: 18 X-Authenticated-User: cstuntz Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail