> I have simplified the query and added the last advise that you told me: > > Query: > > explain analyze select * from (select * from entity_compounddict2document where name='ranitidine') as a order by a.hepval; > Do you need full result?
If you need just top-n rows, then index on entity_compounddict2document(name, a.hepval) might help. Regards, Vladimir Sitnikov
