On Tue, Aug 26, 2003 at 17:48:38 -0300,
Rhaoni Chiu Pereira <[EMAIL PROTECTED]> wrote:
> when I need for just one query a especific index to be used the only way is to
> raise the costs ?
There is no way to say to use a specific index. You can turn off some plans
(and raise the cost of sequenti
On Tue, Aug 26, 2003 at 16:11:56 -0300,
Rhaoni Chiu Pereira <[EMAIL PROTECTED]> wrote:
> 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";
>
>
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.
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.