DB2 10.5 — Catalog data for Expression-Based Indexes

One of the new features in DB2 10.5 is ‘Expression-Based Indexes’. This gives ability to create index on data that is not stored in a table. For expression-based indexes, the result of the expression is stored in the index. Continue reading


Index Cardinality in a DB2 multi-partitioned (DPF) database

Last week, I spent few hours analyzing Index related data in DB2 LUW’s catalog table syscat.indexes and I found something very interesting. In a nut shell, what I learnt is that catalog data that relates to an index’s cardinality in a DPF database is misleading!! Seems like a bold statement..Please read on…

Continue reading