(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:
(Blog) Boost Your Performance – https://tinyurl.com/ydyoaats
(DBI/Blog) Advice: IREF – https://tinyurl.com/ybwadpuq
(DBI/Blog) Performance: ARSS – https://tinyurl.com/ycxa4cfu
(Xtivia/Blog) IREF, a KPI – https://tinyurl.com/yczv2qag
(Blog) What is a Table Scan – https://tinyurl.com/ya2w9q5v
DBI’s Brother Panther – https://tinyurl.com/yb22k763
Xtivia – http://www.xtivia.com/