Running Fast Queries with SQL in InterSystems IRIS
InterSystems IRIS® data platform provides high-performance, full-featured SQL access. You can use SQL with InterSystems IRIS at scale to perform individual queries on a single CPU core, run parallel queries using dozens of cores, and handle distributed queries across a cluster of InterSystems IRIS servers.
Using SQL features in InterSystems IRIS carries several advantages, including:
- High performance and scalability
- Integration with InterSystems object technology
- Low maintenance
- Support for standard SQL queries and stored procedures
- JDBC and ODBC connectivity
- Automatic parallel query execution
- Transparently distributed queries
Watch the video to begin, then try the exercise below.