[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gnumed-devel] index for v_pat_episodes
From: |
syan tan |
Subject: |
[Gnumed-devel] index for v_pat_episodes |
Date: |
Mon, 25 Sep 2006 06:58:48 +1000 |
User-agent: |
KMail/1.8.3 |
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] index for v_pat_episodes,
syan tan <=