Hi Ian >The performace increase wad better than I expected. Results were very >similar for the handful of pv_ids I tried. The main problem of a compressed table (or partition) is the poor = support of DML statements. That said, if you can either reorganize it = when the data is mostly read-only or only do direct inserts, it's a = great feature! Just my 2 cents... Chris -- //www.freelists.org/webpage/oracle-l