Talk to the Veterans Crisis Line now
U.S. flag
An official website of the United States government

VA Health Systems Research

Go to the VA ORD website
Go to the QUERI website

VA Informatics and Computing Infrastructure

SQL Query Optimization for Researchers


by Andrew Holbrook, BS
Seminar date: 2/8/2024

Description: This presentation will cover SQL query optimization techniques and resources, specifically focusing on the types of queries that often give research teams trouble. Some basic concepts will be covered that will be useful to beginners, but most of the presentation will require at least early-intermediate SQL skills to fully understand. We will cover both general best practices and specific common issues.

Intended Audience: VINCI SQL users, especially those who run expensive queries.

View archived session video:



DOWNLOAD: PDF handout | Audio only (mp3) | transcript


Questions about the HSR website? Email the Web Team

Any health information on this website is strictly for informational purposes and is not intended as medical advice. It should not be used to diagnose or treat any condition.