Received: from sectorbase2.sectorbase.com ([208.48.122.131]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA20725 for ; Thu, 25 May 2000 13:22:48 -0400 (EDT) (envelope-from vmikheev@SECTORBASE.COM) Received: by SECTORBASE2 with Internet Mail Service (5.5.2650.21) id ; Thu, 25 May 2000 10:16:17 -0700 Message-ID: <8F4C99C66D04D4118F580090272A7A23018C05@SECTORBASE1> From: "Mikheev, Vadim" To: "'Tom Lane'" , Bruce Momjian Cc: "'Hiroshi Inoue'" , Ryan Bradetich , pgsql-sql@postgresql.org Subject: RE: Use of index in 7.0 vs 6.5 Date: Thu, 25 May 2000 10:17:41 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200005/147 > Yeah, a scan over just the index itself would be a perfect way to ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ I believe that Oracle updates index statistic on-fly... Meta-page is always in cache for inserts, so there will be no additional reads. > gather stats. The normal objection to it (can't tell whether entries > correspond to currently-valid tuples) doesn't apply, because we don't > really care whether the stats are perfectly accurate. Vadim