Re: quick statistics question

On Wed, Dec 17, 2014 at 10:06 AM, Powell, Mark <mark.powell2_at_hp.com> wrote:

> You do not have to delete the statistics before you force the statistics
> to be re-gathered if you are going to use gather_table_statistics. If will
> replace what is there.
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Maureen English
> *Sent:* Wednesday, December 17, 2014 10:25 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* quick statistics question
>
>
>
> We just migrated our reporting instance from 10g to 11g and I planned to
> let Oracle do all the
>
> statistics gathering using the automatic jobs. Unfortunately, I also
> imported the statistics from
> the old database as part of the migration and now I have queries that are
> consistently hanging.
>
> I think I need a sanity check. Does it make sense to delete the
> statistics on the tables
>
> involved in these queries, and then gather them with the basic gather
> table stats statement?
>
> Since these are all materialized views that get refreshed (either complete
> or fast) just about
> every night, I was hoping that Oracle would just decide that statistics
> needed to be generated
> on them after they were refreshed.
>
> - Maureen
>

--
http://www.freelists.org/webpage/oracle-l