Oracle Logbook

June 18, 2012

Biggest difference between analyze and dbms_stats

Filed under: Uncategorized — Helio Dias @ 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.

Create a free website or blog at WordPress.com.