db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <msat...@gmail.com>
Subject Re: Can I clear statistics?
Date Tue, 24 Mar 2009 13:57:32 GMT
Currently, there is no way to drop the statistics neither is there an
optimizer override I think to say do not look at the statistics. But
hopefully other optimizer overrides can help tweak the query plan for
an experienced user.

Mamta

On Tue, Mar 24, 2009 at 5:58 AM, Kathey Marsden
<kmarsdenderby@sbcglobal.net> wrote:
> If I update (enable) statistics  on a table and then find performance is
> worse or decide it is not worth the trouble having to update them
> periodically, is there a way to clear statistics so that I can go back to
> the original plan selection or am I committed to using statistics and
> updating periodically once I update them once?
>
> Thanks
>
> Kathey
>
>

Mime
View raw message