#267: CDM V3 Vitals.Smoking History compliance
-----------------------------------+----------------------------
Reporter: campbell | Owner: mprittie
Type: design-issue | Status: reopened
Priority: major | Milestone: data-domains3
Component: data-stds | Resolution:
Keywords: Smoking history DM V3 | Blocked By:
Blocking: 263, 486 |
-----------------------------------+----------------------------
Comment (by dconnolly):
Mike, more suggestions when stepping through queries takes a long time, in
addition to saving intermediate results in a table or adding indexes:
1. add where clause constraints.
- e.g. constrain the observation fact table to one week of data.
2. Oracle has a [http://stackoverflow.com/a/12502153 SAMPLE thingy] that
can help too.
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/267#comment:20>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
