Article View: borland.public.interbase.sql
Article #65Re: speedup stored procedure
From: Bill Todd [TeamB]
Date: Mon, 26 May 2008 23:32
Date: Mon, 26 May 2008 23:32
11 lines
1449 bytes
1449 bytes
Isaac wrote: > about SET STATISTICS how often I should use it ? > is here a way to make it done automatically in interBase ? Only when you do something that dramatically changes the selectivity of the index, that is, when you do something that changes the ratio of the number of unique values to the total number of rows. -- Bill Todd (TeamB)
Technical Details
Message-ID:
<483b489a$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!feeder.erje.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<483af1a3@newsgroups.borland.com> <483afcd1$1@newsgroups.borland.com> <483b0303@newsgroups.borland.com> <483b0bfe$1@newsgroups.borland.com> <483b1c76@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,bbbc202de7cd9140
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd [TeamB]" <no@no.com>
Subject: Re: speedup stored procedure
Newsgroups: borland.public.interbase.sql
References: <483af1a3@newsgroups.borland.com> <483afcd1$1@newsgroups.borland.com> <483b0303@newsgroups.borland.com> <483b0bfe$1@newsgroups.borland.com> <483b1c76@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.9
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 63.147.41.232
Message-ID: <483b489a$1@newsgroups.borland.com>
Date: 26 May 2008 16:32:42 -0700
X-Trace: newsgroups.borland.com 1211844762 63.147.41.232 (26 May 2008 16:32:42 -0700)
Lines: 11
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!feeder.erje.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail