Optimizing SQL Queries in InterSystems IRIS
See how to optimize SQL queries in InterSystems IRIS® data platform by showing and interpreting query plans, adding bitslice and bitmap indices, and reviewing your query’s performance over time.
Prerequisite Learning or Experience Running Fast Queries with SQL in InterSystems IRIS (exercise, 10m) or basic experience using SQL in InterSystems IRIS.
Audience This exercise is intended for developers with some SQL experience who need to create optimized queries.
Level of Difficulty Intermediate
Learning Objectives After completing this exercise, you will be able to:
Show and interpret a query plan.
Add and test the effects of bitslice and bitmap indices.
- View query performance over time.
Grading Criteria This exercise is not graded.
Resources Needed None.