SHRINE Query Quick Reference

Contents Query Topics Data Steward Guidelines for Query Topics Sample Query Topic Query Construction Tool Logic Constraints Term Values Query Optimization Results: Query Status View [ SHRINE Help Main Menu ] | ## Query Optimization Tips for optimizing your query include the following: Select the most-limiting terms first. For example, demographic data is broader in scope than diagnoses or lab values. Therefore, if you select your diagnoses or lab value terms first and then select your demographic terms, SHRINE returns your query results more quickly. Queries that include lab values require a longer processing time that diagnoses or medications. Consider including either diagnoses or medication terms in your first groups before adding a lab test term to your query. When a term category maps to more than 120 specific terms, there are too many values to process and you cannot use the full category in your query. This is an indication that broader terms and multiple terms process more slowly than narrow or fewer terms. You might consider running multiple queries with simpler criteria in place of one complex query.