Investigate performance of CreateVocabMapTables()
Opened this issue · 0 comments
AnthonyMolinaro commented
See if we can improve the performance of create_source_to_standard_vocab_map.sql and create_source_to_source_vocab_map.sql
Given the recent optimization in ATLAS generated cohort sql, the step 1 would be to replace CTEs with temp tables.