The Oracle Sponge

Oracle Data Warehouse Design and Architecture

Archive for April 13th, 2008

Choosing An Optimal Stats Gathering Strategy

Posted by David Aldridge on 2008-04-13

Greg Rahn has an excellent entry on statistics gathering and the use and abuse of dbms_stats and initialization parameters at the Structured Data blog, one of my favourites. I added a comment on dynamic sampling, of which I am a big proponent, and Greg has another recent post on a case where dynamic sampling saved the day. Hey, I commented on that too …

Posted in Oracle | 2 Comments »