Informix SQL Explain – Using the SQL Optimizer Query Explain Plan

Presented by Lester Knutsen on October 31, 2019


How does the Informix SQL Optimizer choose which index or table or access method to use when running your SQL? This presentation will focus on how to view and understand the SQL Explain plan to see how your SQL is executed. The SQL Explain plan will provide times for each step in your process.