Re: How frequently: Analysing

Hello!

Few key points:
1) If the data in yout table doesn't change - there's no need to reanalyze. Urgent need for analyze comes after large inserts mainly, also deletes. Analyze after large updates is mostly needed when you use histograms or update lots of values to NULL or from NULL (because of indexes). 2) If your server does nothing during the nights anyway, why not analyze, even use compute statistics, that way you use your investment better :)

You might want to separate analyzing less-changing tables/indexes from more-changing ones and analyze first ones weekly, second ones daily for example. But in small environment, don't bother.. just do it daily.

Comments welcome,
Tanel.

<76434.1353_at_compuserve.com> wrote in message news:3e53c8e3.21360464_at_news.hccnet.nl...
> How often should I analyse the user tables in the system?
> Currently a job is doing this every morning which causes some log
> switching (5 x 10MB).
>
> The tables are slowly growing everyday but the structure or the number
> of tables and indexes is not changing.
> How frequently analysing is advised?
> Thanks
Received on Wed Feb 19 2003 - 14:58:30 CST