Re: [Gnumed-devel] index for v_pat_episodes

[Karsten Hilbert]

> select for a fk_patient value on v_pat_episodes will do a sequential scan
> when 
> the conditional clause and fk_health_issue = null is added, 
> but if a partial index is created  , then this should be fixed to an index
> scan.
True.


> CREATE INDEX episode_null_health_issue ON clin.episode( fk_patient) where 
> fk_health_issue is null;

Added to CVS. This should speed up clin.v_pat_narrative_soap if you want to use 
that instead of clin.v_pat_narr3.

Karsten

-- 
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! 
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer