Re: Analyze table
From: Hans-Juergen Schmitz <schmitz_at_rkhtcnw1.ngate.uni-regensburg.de>
Date: Fri, 18 Jun 1999 09:12:30 +0200
Message-ID: <3769F15E.5E22_at_rkhtcnw1.ngate.uni-regensburg.de>
Date: Fri, 18 Jun 1999 09:12:30 +0200
Message-ID: <3769F15E.5E22_at_rkhtcnw1.ngate.uni-regensburg.de>
Hello,
I add a question:
> It you run with the cost based optimizer, then you must re-analyze your
> objects on a periodic basis (depending on the amount of dml you perform on
> the data).
My optimzer_mode paramter is set to default (CHOOSE). There is a table, which had(!) statistics.
At several times I executed "ANALYZE TABLE XXX DELETE STATISTICS"
This happens, but some weeks ago, statistics are present again.
Is there any automatic mechanism for that?
sincerly Hans-Jürgen Received on Fri Jun 18 1999 - 09:12:30 CEST