(Ep. 18) - Db2 Performance Tuning With IREF

There are tons of metrics to show pain, but there are just as many to show efficiency. Index Read Efficiency (IREF) is a way to find SQL performance hogs that you may not normally catch. In today's episode, we will talk about the metric and how to interpret it.

Timestamps:
01:03 - What is Index Read Efficiency (IREF)
02:12 - IREF Threasholds
03:13 - IREF in context with Workload Type (ARSS)
05:32 - Analyzing Example Output
08:30 - SQL for find ARSS and IREF
10:13 - Github Repository with SQL

Useful Links:

[rscarawa]

In the IREF table, what are the units represented? What does <10 mean?