Force query to use index

From: Dennis <dennis(at)zserve(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Force query to use index
Date: 2001-06-18 17:33:43
Message-ID: 9gle1o$22jr$2@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2001-06-18 17:36:44 Re: casts and conversions
Previous Message Oleg Bartunov 2001-06-18 17:28:38 Re: Better Archives?