Re: Not all table analyzed!

From: Marco De Benedetto <debe_at_galliera.it>
Date: Thu, 28 Oct 1999 23:17:55 +0000
Message-ID: <3818D9A3.3FADF5DC@galliera.it>

Marco De Benedetto wrote:
> I think I have found the problem: the day before I analyzed
> (estimatete statistic) most, not all, tables so I guess that
> Oracle was trying to analyze tables not yet analyzed in join
> with other analyze because of the cost based optimizer.
> Now a question: how could I 'de'-analyze all tables?
>
> thanks

Sorry this was a stupid question
analyze table delete statistics

bye Received on Thu Oct 28 1999 - 18:17:55 CDT

This message: [ Message body ]
Next message: Kathy Diez - Computer Managment Consult.: "Notice to ALL Oracle Professionals"
Previous message: strausy_at_my-deja.com: "TNSListner on Sun Solaris"
In reply to: Marco De Benedetto: "Not all table analyzed! (was Performance ok only after recreaction of a table)"
Next in thread: NetComrade: "Re: Performance ok only after recreaction of a table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US