Skip to content

[SQL Tuning]derive_standard_drug_outcome_contingency_table_1.sql ~ 5sql  #17

@ParkChanghHyun

Description

@ParkChanghHyun

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions