Home > mailing lists

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

From	Kimberly Israel
Subject	Re: Using index name in select Query
Date	October 19, 2013 15:45:51
Msg-id	1382186713.79837.YahooMailNeo@web161604.mail.bf1.yahoo.com Whole thread Raw
In response to	Using index name in select Query (Naman <naman.bbps@gmail.com>)
List	pgsql-novice

I'm not sure what you mean by using a particular index.

If you want the index to be used to order the records, just add and ORDER BY line to the query:

SELECT * FROM student

ORDER BY index1.

On Saturday, October 19, 2013 8:24 AM, Naman <naman.bbps@gmail.com> wrote:

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

From: Naman
Date: 19 October 2013, 15:09:05
Subject: Using index name in select Query

From: David Johnston
Date: 19 October 2013, 16:18:24
Subject: Re: Using index name in select Query