Oracle Logbook

June 18, 2012

Biggest difference between analyze and dbms_stats

Filed under: Uncategorized — heliodias @ 5:46 pm

Analyze collect statistics from the indexes associated within a table and dbms_stats don´t.

Using dbms_stats you should add the parameter cascade=>true to accomplish the same result.

Advertisements

Blog at WordPress.com.