From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rajesh Kumar Mallah <mallah@trade-india.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: analyse question..
Date: Thu, 17 Apr 2003 12:04:53 -0400
Message-ID: <11148.1050595493@sss.pgh.pa.us> (raw)
In-Reply-To: <200304172026.36334.mallah@trade-india.com>
References: <200304171351.19189.mallah@trade-india.com>
<10379.1050589051@sss.pgh.pa.us>
<200304172026.36334.mallah@trade-india.com>
Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> On Thursday 17 Apr 2003 7:47 pm, Tom Lane wrote:
>> Rajesh Kumar Mallah <mallah@trade-india.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, mallah@trade-india.com
Subject: Re: analyse question..
In-Reply-To: <11148.1050595493@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox