You are correct. ANALYZE on table automatically collects the statistics for each of the table's indexes and domain indexes, provided that no for_clauses are used.Originally posted by UNIX DBA
I thought that analyzing the tables also analyzed the indexes. For all indexes only analyzes the index.
Sam




Reply With Quote