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; _______________________________________________ Gnumed-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnumed-devel
