How to force an Index ?

From: Rhaoni Chiu Pereira <rhaoni(at)sistemica(dot)info>
To: Lista PostgreSQL <pgsql-admin(at)postgresql(dot)org>
Subject: How to force an Index ?
Date: 2003-08-26 19:11:56
Message-ID: 1061925116.3f4bb0fc641b2@www.sistemica.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi List,

I'm looking for a way to force an Index to be used in a SQL query. In a
Oracle SQL query it would be like:

Select /*+ my_index*/ * from my_table where my_name="rhaoni";

So it would use the index my_index to execute the query. How can I make this
in a PostgreSQL SQL query.

Atenciosamente,

Rhaoni Chiu Pereira
Sistêmica Computadores

Visite-nos na Web: http://sistemica.info
Fone/Fax : +55 51 3328 1122

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2003-08-26 19:45:58 Re: How to force an Index ?
Previous Message Chris Miles 2003-08-26 18:24:18 Re: Automated backup problems - pg_dump