[SQL Tuning]derive_standard_drug_outcome_contingency_table_1.sql ~ 5sql #17
Description
Previous 「Derive standard drug outcome (FAERS reaction) 2x2 contingency tables」 step need too much long time.
So I tuning the SQL code.
Originally it didin't work (it need to toomuch longetime).
But After change "Left OUTER JOIN SQL LOGIC", it works in just minute.
(PCH change)derive_standard_drug_outcome_contingency UNION.txt
I propose the update in Git.
master...ParkChanghHyun:faersdbstats:patch-1