Re: Using index name in select Query

Actually as part of project i have to achieve following task :

suppose i have a table t1(a,b,c,d)

I make an index as :
CREATE INDEX index_abcd on t1(a) WHERE a is NOT NULL and b IS NULL and c
IS NULL and d IS NOT NULL.

There is a high probability but not 100% that optimizer will use the above
index if following query is fired :

SELECT * FROM t1 WHERE a=2 and b IS NULL and c IS NULL and d IS NOT NULL

Now my requirement is if i know the index name i.e. index_abcd then is there
a way by which i can use it in the select query so that i can be sure that
optimizer will pick the index specified(i.e index_abcd) and no other.

Some other databases like mySql have this provision using USE INDEX clause

I want something similar in postgresql

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Using-index-name-in-select-Query-tp5775138p5775143.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.