X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 193A44758F1 for ; Thu, 17 Apr 2003 12:04:50 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id D7CAE475458 for ; Thu, 17 Apr 2003 12:04:48 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h3HG4sU6011149; Thu, 17 Apr 2003 12:04:54 -0400 (EDT) To: Rajesh Kumar Mallah Cc: pgsql-sql@postgresql.org Subject: Re: analyse question.. 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> Comments: In-reply-to Rajesh Kumar Mallah message dated "Thu, 17 Apr 2003 20:26:36 +0530" Date: Thu, 17 Apr 2003 12:04:53 -0400 Message-ID: <11148.1050595493@sss.pgh.pa.us> From: Tom Lane X-Spam-Status: No, hits=-32.3 required=5.0 tests=BAYES_00,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/281 X-Sequence-Number: 12982 Rajesh Kumar Mallah writes: > On Thursday 17 Apr 2003 7:47 pm, Tom Lane wrote: >> Rajesh Kumar Mallah 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