Topic outline

• Optimizing Your SQL Queries

  Optimizing Your SQL Queries

  Content Type
  Video

  Duration
  50m

  Level
  Intermediate

  See how to identify poorly performing SQL queries and improve their speed using the SQL optimization tools available in InterSystems IRIS® data platform.

  
  

  Refer to the PDF slide deck that goes along with this video.

  • Mark me "complete" for this video.

• Code Used in This Video

  Code Used in This Video

  Reference	Timestamp	Code
  Create an index using DDL	30:40	CREATE INDEX IndexName on TableName (ColumnName)
  Create an index in a class	32:00	Index IndexName on Column;
  Build an index	32:25	do ##class(Package.Class).%BuildIndices()
  Store data in an index	33:35	Index IndexName on Column [Data =(Property1, Property2)];
  Create a compound index	36:15	Index IndexName on (Column1, Column2) [Data =(Property1, Property2)];
• What's Next?

  What's Next?
  • Learn more about identifying and improving slow queries (video, 9m).
  • Try out the SQL optimization tools mentioned in this video (exercise, 15m).