<div dir="ltr"><span style="font-size:12.8000001907349px">Hi,</span><div style="font-size:12.8000001907349px"> I
usePostgres 9.4 database.Now,I am optimizing the queries by using the results of "explain" and "explain
analyze",SometimesI am creating Indexes to optimize them. But, I was not successful sometimes as even I create Index to
optimizethem, the planner is not using them .</div><div style="font-size:12.8000001907349px"><br /></div><div
style="font-size:12.8000001907349px"><spanstyle="white-space:pre-wrap"> </span>So my question was can we know whether
theplanner will use the index before actually creating a real Index..or can we create "virtual" or "Hypothetical"
Indexthose can only be known to the planner and not the user or Is there any alternative to do it..If present,share
withme.</div></div>