PPT Slide

The daily grind

The System Catalog tables

Tracking Index Information

select tabname, idxname, levels, leaves, nunique, clust

from systables st, sysindexes si

where st.tabid = si.tabid

order by 1, 3 ASC, 4 ASC;