Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 4CD9E9FB7E4
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 13 Jul 2007 17:01:32 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 73490-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 13 Jul 2007 17:01:24 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from rootabega.88thstreet.com (dsl254-071-237.nyc1.dsl.speakeasy.net
	[216.254.71.237])
	by postgresql.org (Postfix) with ESMTP id DFF139FB715
	for <pgsql-sql@postgresql.org>; Fri, 13 Jul 2007 17:01:28 -0300 (ADT)
Received: from www.88thstreet.com (localhost [IPv6:::1])
	by rootabega.88thstreet.com (8.13.3/8.13.3) with ESMTP id
	l6DK1HnB012415
	for <pgsql-sql@postgresql.org>; Fri, 13 Jul 2007 16:01:21 -0400 (EDT)
Received: from 63.118.86.10 (SquirrelMail authenticated user radhika)
	by www.88thstreet.com with HTTP;
	Fri, 13 Jul 2007 16:01:21 -0400 (EDT)
Message-ID: <48624.63.118.86.10.1184356881.squirrel@www.88thstreet.com>
Date: Fri, 13 Jul 2007 16:01:21 -0400 (EDT)
Subject: Bitmap Index Scan 
From: "Radhika Sambamurti" <radhika@88thstreet.com>
To: pgsql-sql@postgresql.org
Reply-To: radhika@88thstreet.com
User-Agent: SquirrelMail/1.4.5
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
Importance: Normal
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200707/85
X-Sequence-Number: 28820

I am using Postgres 8.2.0.
Is there a way to explicitly make the planner use bitmap index scan on  a
field?


Thanks.
Radhika


-- 
It is all a matter of perspective. You choose your view by choosing where
to stand.
Larry Wall
---