At 17:05 09/03/2004 +0100, you wrote:

>Hi Ian,
>
> > Thanks for the idea Martijn,
> >
> > Heres the stored procedure to do the job!
> >
> > CREATE PROCEDURE SYS_RECALC_SELECTIVITY
> > returns (indexname char(31))
> > AS
> > begin
> > for select rdb$index_name from rdb$indices into :indexname do
> > begin
> > execute statement 'set statistics index ' || :indexname;
> > suspend;
> > end
> > end
>
>Why are you making this procedure selectable?
>(suspend)

I asked to myself the same....

But I think that it is to show the progress... I liked the idea... :)

>With regards,
>
>Martijn Tonies
>Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
>Server.
>Upscene Productions
>http://www.upscene.com
>

See you !


Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.596 / Virus Database: 379 - Release Date: 26/02/2004


[Non-text portions of this message have been removed]