Re: analyse question..

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: analyse question..
Date: 2003-04-17 16:04:53
Message-ID: 11148.1050595493@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> writes:
> On Thursday 17 Apr 2003 7:47 pm, Tom Lane wrote:
>> Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> writes:
>>> Do we need to analyze a table after indexing ?
>>
>> No.

> Doesnt' it mean we shud analyze after index creation so that
> statiscs are updated?

No, because the statistics are independent of whether an index exists or
not. You can do it in either order and get the same results.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-04-17 16:10:32 Re: planner question..
Previous Message Manfred Koizar 2003-04-17 16:02:12 Re: getting rid of "Adding missing FROM-clause entry...."