Subject Re: Updating index statistics
Author lacakus
Hi = m. Th =",
I agree with you. Auto Stat is feature, which, we "must have".
I have post also in devel list (as LacaK) link to Microsoft web site
(as auto stats work in SQL Server).
I am not aware of Firebird internals, so I can not get a 'real'
solution.
I hope, that FB developers are conscious of this problem and will
find solution (in near future ? :-)).
If there is feature request in tracker, we can vote for, to adjust
priority :-)
(but I am not able find such item in feature request tracker ... I
post to devel-list question about such feature request, but my post
is 'invisible' ... hold by administrator)
-Laco.
>
> Ann W. Harrison wrote:
> > lacakus wrote:
> >
> >> If I understand it correctly, when :
> >> 1. I create a new database, tables, constraints and indexes (new
empty
> >> database)
> >> 2. then I start working with this database, so insering,
updating,
> >> deleting rows in tables
> >> 3. and I newer run set statistics, alter index or backup/restore
> >> 4. then statistics information (on indexes) newer changes (from
step
> >> 1) ?
> >>
> >>
> >
> > That's right.
> >
> >
> Yes, and with this we must fight :) AFAIS, very few users take care
to
> update their statistics and complain that the Firebird is slow.
Never
> forget: "When every thing is going ok the glory is attributed to
the
> user, when something is going wrong the programmer is to blame".
Here,
> you are the programmer <g>. I'm with you :-) (Perhaps you can help
to
> find the best solution on the thread from the 'devel' list).
>
> All best wishes,
>
> m. th.
> > Regards,
> >
> >
> > Ann
>