Using index name in select Query

From: Naman <naman(dot)bbps(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Using index name in select Query
Date: 2013-10-19 05:32:58
Message-ID: CAO=k+Z_OsjfUYzpg4QLHxFRboN-XyG+DbZtGtx5fdOKmF-2VZg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Kimberly Israel 2013-10-19 12:45:13 Re: Using index name in select Query
Previous Message Erin Jonaitis 2013-10-18 15:27:40 Re: Restoring from SQL dump