This content has been marked as final. Show 1 reply
ma365 wrote:Yes, this is what SQL Reference doc.says http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_4005.htm#i2086320:
1. What affect does the ANLAYZE TABLE xxxxx VALIDATE STRUCTURE command have on the existing statistics?
My current understanding is that these commands do not touch the optimizer statistics. Is this correct?
Specify VALIDATE STRUCTURE to validate the structure of the analyzed object. The statistics collected by this clause are not used by the Oracle Database optimizer, as are statistics collected by the COMPUTE STATISTICS and ESTIMATE STATISTICS clauses.