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