SQL
InterSystems IRIS for Health™ provides high-performance, full-featured SQL access. You can use SQL with InterSystems IRIS for Health at scales from queries running on a single CPU core, to parallel queries using dozens of cores, to distributed queries across a cluster of InterSystems IRIS for Health servers.
InterSystems SQL is fully integrated with InterSystems IRIS for Health object technology and also provides connectivity with ODBC and JDBC clients. Other features include automatic parallel query execution, transparently distributed queries, and support for both standard SQL queries and stored procedures.
Get Started
-
Try a hands-on exerciseOpens in a new tab on running fast SQL queries in InterSystems IRIS.
-
InterSystems SQL OverviewOpens in a new tab is an online course that gives a hands-on introduction to class queries, dynamic SQL, and embedded SQL.
Categories
-
Using InterSystems SQL provides information about using SQL with InterSystems databases.
-
InterSystems SQL Performance Optimization explores performance optimization tools.
-
InterSystems SQL Reference offers detailed reference information on InterSystems SQL commands, functions, operators, and more.
-
SQL Gateway Overview describes how to enable InterSystems IRIS for Health to access external databases via both JDBC and ODBC.