Skip to main content

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

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.

FeedbackOpens in a new tab