From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | lima_caetano(at)yahoo(dot)com(dot)br (Marcio Caetano) |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Specifying a index |
Date: | 2004-02-03 23:33:17 |
Message-ID: | 2879.1075851197@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
lima_caetano(at)yahoo(dot)com(dot)br (Marcio Caetano) writes:
> 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
> Is it possible specify which index (IDXA or IDXB) my SELECT will use in a query ?
No, not directly, but why would you create duplicate indexes? It would
be reasonable to have two indexes on the same column if they supported
different operator classes, but in that case the operator used in a
particular query would determine which index is applicable.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2004-02-04 00:09:19 | Re: BLOB problem |
Previous Message | Tom Lane | 2004-02-03 23:31:15 | Re: BLOB problem |