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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html