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.


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

View raw message