Specifying a index

From: lima_caetano(at)yahoo(dot)com(dot)br (Marcio Caetano)
To: pgsql-general(at)postgresql(dot)org
Subject: Specifying a index
Date: 2004-02-03 15:04:05
Message-ID: 6e15fe24.0402030704.ae81a6b@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello !

Consider the examples bellow:

1- I create a table named TBA with columns ( A int , B char(10) )
2- I create an B-Tree index named IDXA using the column A
3- I create an GIST (or other) index named IDXB using the column A

So, I ask you:

Is it possible specify which index (IDXA or IDXB) my SELECT will use in a query ?
If so, how ?

Thanks in advance.

Marcio Caetano.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2004-02-03 15:34:21 Re: large crontab database design
Previous Message Marcio Caetano 2004-02-03 14:52:11 Multicolumn Indexing using R-Tree