Re: help:what is the difference btwn two analyze index?

It depends on what you want to achieve because they are kind of different. If you are only interested in getting the statistics updated, use "compute statistics".

[From technet]
COMPUTE STATISTICS

• computes exact statistics about the analyzed object and stores them in the data dictionary. When you analyze a table, both table and column statistics are collected.

VALIDATE STRUCTURE
-- validates the structure of the analyzed object. The statistics collected by this clause are not used by the Oracle optimizer, as are statistics collected by the COMPUTE STATISTICS and ESTIMATE STATISTICS clauses. For an index, Oracle verifies the integrity of each data block in the index and checks for block corruption. This clause does not confirm that each row in the table has an index entry or that each index entry points to a row in the table. You can perform these operations by validating the structure of the table with the CASCADE clause. Validating the structure of an object prevents SELECT, INSERT, UPDATE, and DELETE statements from concurrently accessing the object. Therefore, do not use this clause on the tables, clusters, and indexes of your production applications during periods of high database activity. Received on Wed Jun 20 2001 - 22:07:51 CDT