How to force an Index ? - Mailing list pgsql-admin

From Rhaoni Chiu Pereira
Subject How to force an Index ?
Date
Msg-id 1061925115.3f4bb0fc02758@www.sistemica.info
Whole thread Raw
List 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






pgsql-admin by date:

Previous
From: Chris Miles
Date:
Subject: Re: Automated backup problems - pg_dump
Next
From: Rhaoni Chiu Pereira
Date:
Subject: How to force an Index ?