Subject | Re: [ib-support] Free Tool for SET STATISTICS on all Indices in your DB |
---|---|
Author | Thomas Miller |
Post date | 2002-10-04T15:11:42Z |
why not make it a function like in Oracle. This may need to wait for
2.0, but it
seems like lots of people would want to run this.
Ivan Prenosil wrote:
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork
http://www.bss-software.com
[Non-text portions of this message have been removed]
2.0, but it
seems like lots of people would want to run this.
Ivan Prenosil wrote:
>>From: Arno Brinkman--
>>
>>
>>>if you periodly SET STATISTCS an your Indices in the DB,
>>>some queries can be much performanter ...
>>>So i made this tool ....
>>>free dl: www.clientel.at/public
>>>
>>>-gerhard
>>>
>>>
>>And with FB1.5 you can create a stored proc with does this for you ;-)
>>
>>
>
>Or you can simply directly update rdb$indices table and commit ;-)
>
>Ivan
>http://www.volny.cz/iprenosil/interbase
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork
http://www.bss-software.com
[Non-text portions of this message have been removed]