Re: dbms_stats.gather_schema_stats with the option gather_auto
From: <michael.spoden_at_web.de>
Date: Mon, 23 Jun 2008 06:12:13 -0700 (PDT)
Message-ID: <af09a4ae-01ec-44a6-8581-affedf0af800@k30g2000hse.googlegroups.com>
Date: Mon, 23 Jun 2008 06:12:13 -0700 (PDT)
Message-ID: <af09a4ae-01ec-44a6-8581-affedf0af800@k30g2000hse.googlegroups.com>
> Again, not without actually generating those statistics.
> GATHER_SCHEMA_STATS isn't a preprocessor to output which objects might
> be processed, it is a procedure to actually generate the statistics
> and report which objects were considered STALE or empty.
David,
any other ideas or possibilites? Received on Mon Jun 23 2008 - 08:12:13 CDT