Postgres Pro
Downloads
Home   >   mailing lists

Using index name in select Query - Mailing list pgsql-novice

From Naman
Subject Using index name in select Query
Date
Msg-id CAO=k+Z_OsjfUYzpg4QLHxFRboN-XyG+DbZtGtx5fdOKmF-2VZg@mail.gmail.com
Whole thread Raw
Responses Re: Using index name in select Query  (Kimberly Israel <kac15228@yahoo.com>)
Re: Using index name in select Query  (David Johnston <polobo@yahoo.com>)
List pgsql-novice
Tree view
Hi

I have table student with index built upon it naming  index1 ,index2 so on and so forth.
I want to write a query by which i can force the optimizer to use the specified index.

Somewhat like :
select * from student use index(index1).

Is there any way to achieve this

Regards
Naman

pgsql-novice by date:

Previous
From: Erin Jonaitis
Date:
Subject: Re: Restoring from SQL dump
Next
From: Kimberly Israel
Date:
Subject: Re: Using index name in select Query