Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5II1Qa07352 for ; Mon, 18 Jun 2001 14:01:26 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f5IHXna68313 for pgsql-sql@postgresql.org; Mon, 18 Jun 2001 13:33:49 -0400 (EDT) (envelope-from news) From: Dennis X-Newsgroups: comp.databases.postgresql.sql Subject: Force query to use index Date: Mon, 18 Jun 2001 11:33:43 -0600 Organization: ZServe Lines: 11 Message-ID: <9gle1o$22jr$2@news.tht.net> Reply-To: dennis@zserve.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit X-Complaints-To: scrappy@hub.org User-Agent: KNode/0.4 To: pgsql-sql@postgresql.org X-Archive-Number: 200106/263 X-Sequence-Number: 3524 Can you force a query to use a specific index? Can I for instance say: select * from tableA where user = 'soandso' and someint = -1 and somedata = 'foo' ; and somewhere in that query tell it to use the tableA_suchandsuch index? -Dennis