Article View: borland.public.interbase.sql
Article #292Re: Store Procedure and IN
From: Craig Stuntz TeamB
Date: Fri, 22 Feb 2008 13:24
Date: Fri, 22 Feb 2008 13:24
19 lines
1984 bytes
1984 bytes
Karol Bieniaszewski wrote: > but he tell that "in select" breake performance That's because he's appending it to the output of the proc, meaning that IB can't account for the IN when it makes the PLAN for the proc. > i know that he must previous optimize Stored proc - but he not > attache code of this proc and my sample also should increase > performance No. Nothing appended to a proc will stop it from doing a full scan. The fix /must/ be inside the proc. -- 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:
<47bedb28$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<47bcbe87@newsgroups.borland.com> <47bd39ef$1@newsgroups.borland.com> <47bd3ecc$1@newsgroups.borland.com> <47bd4554@newsgroups.borland.com> <47bd4591$1@newsgroups.borland.com> <47bda92b$1@newsgroups.borland.com> <47be7e23$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,5e0810130fee05d6 X-Google-Attributes: gid114a0e,public,usenet X-Google-Language: ENGLISH,ASCII From: "Craig Stuntz [TeamB]" <craig_stuntz@nospam.please [a.k.a. acm.org]> Subject: Re: Store Procedure and IN Newsgroups: borland.public.interbase.sql References: <47bcbe87@newsgroups.borland.com> <47bd39ef$1@newsgroups.borland.com> <47bd3ecc$1@newsgroups.borland.com> <47bd4554@newsgroups.borland.com> <47bd4591$1@newsgroups.borland.com> <47bda92b$1@newsgroups.borland.com> <47be7e23$1@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: <47bedb28$1@newsgroups.borland.com> Date: 22 Feb 2008 06:24:40 -0700 X-Trace: newsgroups.borland.com 1203690280 64.199.116.234 (22 Feb 2008 06:24:40 -0700) Lines: 19 X-Authenticated-User: cstuntz Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail