[Gnumed-devel] index for v_pat_episodes

[syan tan]

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.

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