PPT Slide

The daily grind

The System Catalog tables

Finding indexed columns

select st.tabname, si.idxname, c1.colname, c2.colname, …

from systables st, sysindexes si, syscolumns c1, syscolumns c2, syscolumns c3, …

where st.tabid = si.tabid

and si.tabid = c1.tabid and abs(si.part1) = c1.colno

and si.tabid = c2.tabid and abs(si.part2) = c2.colno

…

order by 1, 2;