On Fri, Jul 10, 2015 at 2:34 AM, Nicolas Paris wrote:
>
>
> =3: without a constraint on tval_char => seq
> scan
>
>
> EXPLAIN ANALYSE select f.patient_num
> from i2b2data_multi_nomi.observation_fact f
> where
> f.co
Ok, here is the problem (it's different than what I explained before)
==INDEX ==
CREATE INDEX of_idx_modifier
ON i2b2data_multi_nomi.observation_fact
USING btree
(concept_cd COLLATE pg_catalog."default", modifier_cd COLLATE
pg_catalog."default", valtype_cd COLLATE pg_catalog."default", tval_c