improve performance of complex queries

bp2014n2 / i2b2

Bachelor project in order to use i2b2 with big data

http://bp2014n2.github.io/

4 stars 0 forks source link

improve performance of complex queries #191

Closed SvenLehmann closed 9 years ago

SvenLehmann commented 9 years ago

How to handle queries on temp tables that do not have an index?

update QUERY_GLOBAL_TEMP set panel_count =1 where QUERY_GLOBAL_TEMP.panel_count = 0 and exists ( select 1 from (select patient_num from MASTER_QUERY_GLOBAL_TEMP where master_id = \'masterid:2110\') t where QUERY_GLOBAL_TEMP.patient_num = t.patient_num )