Subject | Re: [ib-support] Index on Boolean-Col |
---|---|
Author | hans@hoogstraat.ca |
Post date | 2001-08-20T03:03:12Z |
I see my RBD$STATISTICS Rane from 0 to 9.5.
Are these dynamically updated.
Can I use them somehow to fine tune my system performance ?
Best Regards
Hans
======================================================
Zile wrote:
Are these dynamically updated.
Can I use them somehow to fine tune my system performance ?
Best Regards
Hans
======================================================
Zile wrote:
>
> ____
> _/\/ando,
>
> >both you and Guido seem to imply that the value that you set with SET
> >STATISTICS is the selectivity of an index.
>
> I do not imply anything, just trying to better understand how IB works.
>
> >In particular, I don't think that the selectivity of an index is
> >something that IB keeps track of or use.
>
> Try this:
>
> select rdb$index_name, rdb$relation_name, rdb$statistics
> from rdb$indices
> where rdb$system_flag is null
>
> Regards
>
> Zile
>
>
> 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/